18 Comments

  1. balagangadharreddy
    May 27, 2011 @ 12:31 pm

    very good documents

    Reply

  2. Preeti
    June 13, 2011 @ 3:37 pm

    nice documents.. helped to understand better….

    Reply

  3. Narendar Reddy.Bijjam
    June 25, 2011 @ 7:34 am

    This code is very useful to every oracle apps student

    Reply

  4. Khushbu
    June 29, 2011 @ 2:35 pm

    Excellent document to refer….

    Reply

  5. ksatya
    August 3, 2011 @ 4:57 pm

    hai u gave best of best notes regarding the SQl * loader it helps us a lot hope we are expecting this type of articles

    Reply

  6. Phani Adusumilli
    August 9, 2011 @ 7:51 pm

    Can we load line number in the file to the table, so that we can refer join by record level when we are loading multiple tables without using the sequence number. Since the sequence number keeps on the incrementing. I want some think like record # 1,2,3,… for each file i load.

    — Thanks,
    Phani Adusumilli

    Reply

  7. Phani Adusumilli
    August 9, 2011 @ 11:11 pm

    Used SEQUENCE(1,1) gives record count from 1, for 0 use SEQUENCE(0,1)

    — Phani Adusumilli

    Reply

  8. Ram_POsam
    September 16, 2011 @ 10:10 am

    SUPERB DOCUMENTS IT IS VERY USEFUL FOR ME.THANK U……….

    Reply

  9. Shyam
    November 11, 2011 @ 6:28 pm

    One question : I have the following scenario. Can you please tell me how the control file should be like? It is a pipe delimited file.
    Fields to be loaded –
    emp_num
    emp_name
    status_date
    dept_num
    dept_name
    location_id
    location_name

    dept_num and dept_name should have the same values as emp_num and emp_name. Eg data:

    123|David|09081999|10|NewYork

    345|Peter|08122001|20|Paris

    I have to re-read fields 1 and 2 and then continue from where I left off.

    Please help.

    Reply

  10. debi
    February 6, 2012 @ 3:17 pm

    Excellent Document for oracle apps student who really want regarding SQL LOQADER in short span of time….

    Reply

  11. Prasad
    February 28, 2012 @ 2:48 am

    Thanks for the detailed information, wondering if there is a way to load the filename using SQL loader

    Reply

  12. Abhinay
    March 4, 2012 @ 3:20 pm

    Nice one. I have a question. Using ‘WHEN’ is causing me an issue in SQL loader. I have input files say for example
    Type,Data,Status
    Value1,Testing Data,
    Value2,Testing Data2, A
    Value2,Testing Data2, B
    Value3, Testing Data3,

    Now I want to skip rows from input file when Type = ‘Value2′ and Status =’A’

    I am not able to do this. I have used like “WHEN Type = ‘Value2′ AND Status ‘A'” condition
    but the sql loader rejects all records of Type ‘Value2′ …

    Can you please help?

    Reply

  13. Raja Dutta
    July 19, 2012 @ 1:27 pm

    How to Skip Columns in a Delimited Datafile using SQLLoader

    Suppose I have a data file:

    1,ABCD,200.00
    2,WXYZ,300.00

    my table structure is
    tab(c1,c2)

    Now I want to insert data from 2nd column onwards i.e I want to skip column 1 in data file.
    c1 c2
    ————————-
    ABCD 200.00
    WXYZ 300.00

    Any idea how to achieve this?

    Reply

  14. Murali Putttaparthi
    October 18, 2012 @ 9:34 am

    There are 5 fields in the Table. The input file contains only 3 fields. Does our control file need to have all the 5 fields in theTable or only those 3 fields is enough in the control file. Please any one can share with me the possible solution.(If possible the Code also).

    Reply

  15. vinay sawant
    December 13, 2012 @ 2:15 pm

    To,
    raja datta

    LOAD DATA

    INFILE ‘eg.dat’

    APPEND

    INTO TABLE TAB

    FIELDS TERMINATED BY “,”

    (desc_skip FILLER POSITION(0),
    C1,
    C2,
    )

    Reply

  16. VAMSI
    October 11, 2013 @ 2:56 pm

    Nice document
    thanks a lot yar….

    Reply

  17. Yogesh
    October 13, 2013 @ 11:49 pm

    Hi Pruthvi,
    This is Yogesh,my suggestion is ,why cant we start a seperate section for Real time interview questions.
    Suppose a guy went to interview and he lost it.if he post the questions in the Real time interview questions so some one can see and answer those questions..as Oracle Apps is rare subject, straight away we don’t get answers in google.
    I think this might be use-full for oracle apps freshers,job seekers and Experienced guys.

    I am sorry if any thing i made mistake.

    regards,
    Yogesh
    yogeshwar419@gmail.com

    Reply

  18. Rahul Chauhan
    April 22, 2014 @ 10:25 am

    Hi All,

    i came across a control file where there is no file name given, from where it is loading the data into table.
    File goes something like–

    OPTIONS(ROWS=10000,ERRORS=2000000,SKIP=1)
    LOAD DATA
    APPEND INTO TABLE XXMAS.PROMISE_DATES
    FIELDS TERMINATED BY ‘|’ OPTIONALLY ENCLOSED BY ‘”‘
    TRAILING NULLCOLS
    (
    ORDER_NUMBER “LTRIM(RTRIM(:ONT_ORDER_NUMBER))”,
    SOURCE_SYSTEM “LTRIM(RTRIM(:SOURCE_SYSTEM))”,
    ITEM_NUMBER “LTRIM(RTRIM(:ITEM_NUMBER))”,
    NEW_PROMISE_DATE Date “YYYYMMDD”,
    PO_NUMBER “LTRIM(RTRIM(:PO_NUMBER))”,
    PO_LINE_NUMBER_CHAR “LTRIM(RTRIM(:PO_LINE_NUMBER_CHAR))”,
    ORDERED_QUANTITY,
    INBOUND_ORG_ID,
    CONV_REQUEST_ID Constant “-1″,
    FILE_REQUEST_ID Constant “-1″,
    CONV_STATUS Constant “FILE”,
    CREATION_DATE Sysdate,
    CREATED_BY Constant “-1″,
    LAST_UPDATE_DATE Sysdate,
    LAST_UPDATED_BY Constant “-1″,
    LAST_UPDATE_LOGIN Constant “-1″,
    ERROR_FLAG Constant ‘N’,
    LOADED_FLAG Constant ‘N’
    )

    Reply

Leave a Reply

Back to Top