sql*loader issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sql*loader issue

  1. #1
    Join Date
    Sep 2003
    Posts
    49

    sql*loader issue

    How can i load nested table data through sql*loader?
    any exmaples

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    you can use the COLUMN OBJECT parameter in control file to indicate an object is loaded.

    example:
    create type NAME_TYPE
    as object
    (
    first_name varchar2(20),
    last_name varchar2(20)
    );
    /

    create table EMP
    (
    EMPNO number,
    ENAME NAME_TYPE
    );

    sqllodr control file:

    LOAD DATA
    INFILE *
    INTO TABLE EMP
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    ( EMPNO ,
    ENAME column object
    (first_name char,
    last_name char)
    )
    BEGINDATA
    1, A1, B1
    1, A2, B2
    3, A3, B3

    Cheers.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

Posting Permissions

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



Click Here to Expand Forum to Full Width