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 Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...