Tuesday, October 24, 2017

Populating Record Number in SQL * LOADER

If you need to populate the sequence of records as they appear in the data file. SQL Loader doesn't necessarily insert data the way it comes in datafile, using RECNUM can help.

Record_ID RECNUM
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...