Results 1 to 2 of 2

Thread: Sqlldr

  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Sqlldr

    I have (many) txt files i have to load into Oracle database with sqlldr utility.

    Is anybody has idea how to avoid inside control file entering all that boring keyword POSITION?
    Is there any format of files where I can avoid POSITION,I mean
    where I can only entering column names,not POSITION(a:b),so sqlldr
    utiliy itself recognize position of columns?
    Thanks for advice,Zvonimir

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Sqlldr

    The alternative to POSITION is to have delimited fields in the data, for example FIELDS TERMINATED BY ','. Then you cna just list the column names.

Posting Permissions

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