SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

external table- add column

sk12345678Apr 28 2010 — edited Apr 28 2010

I have a file with 3 columns delimited with tab.
I want to process this file in a pl/sql program record by record. I want to keep track of the records i have processed in this file. Can I add an extra 4th column flag_column to this external table to keep track of the records processed. If so, how to do it. can some one refer to the syntax. thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 26 2010

Added on Apr 28 2010

#column, #file, #in, #not, #table, #to

5 comments

901 views