SQL*Loader - Datatype

Card Puncher Data Processing

If you cannot use an Oracle Net database link and the datafile must be accessed by SQL*Loader running on the target system, it is advisable to use only the portable SQL*Loader datatypes (for example:

  • CHAR,
  • DATE,
  • VARCHARC,
  • and numeric EXTERNAL.

Datafiles written using these datatypes may be longer than those written with native datatypes. They may take more time to load, but they transport more readily across platforms.





Recommended Pages
Card Puncher Data Processing
Oracle - SQL*Loader

A utility data loader for the Oracle database Reason: NLS_NUMERIC_CHARACTERS is equal to ',.' or '.,' based upon the Territory (NLS_LANG) you are in. Example: The NLS_LANG...



Share this page:
Follow us:
Task Runner