Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: How are the null values handled in SQL Loader?

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    How are the null values handled in SQL Loader?

    How are the null values handled in SQL Loader?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    One way out is -
    If you are using fixed fields in your file holding the data, you would need to specify the character posistions in the controlfile and use NVL to replace the null value with a single space

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics