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)

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)