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 list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...