1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Insert data into Table using SQL*Loader

Discussion in 'Oracle Apps Technical' started by sivasankar.g, Jun 25, 2012.

  1. sivasankar.g

    sivasankar.g Active Member

    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    65
    I Have Flat File like bellow.I want to Insert data Into Emp Table.
    In the Flat file data along with column names
    example..

    ENAME;DILEEP;EMPNO;123;SAL;50000;
    ENAME;KUMAR;EMPNO;456;SAL;60000;
    ENAME;REDDY;EMPNO;890;SAL;70000;


    Please Help on the same.

    Thanks,
    Siva.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
  3. selvaspskj

    selvaspskj Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    It is very simple,
    Open the flat file and find "ENAME;" and replace all with empty.
    this is how you remove all your column name and you will get the fla file as expected. now u can go for sql loader :)