+ Reply to Thread
Results 1 to 3 of 3

Thread: sqlldr

  1. 02-24-2003 10:56 AM #1
    ora_inf
    ora_inf is offline Member
    Join Date
    Jan 2001
    Posts
    230

    Question sqlldr

    Hi:

    I want to load 16:25 into Number filed as 16.25 from flat file using sqlldr.

    any suggetion?

    Thanks.
    Reply With Quote Reply With Quote
  2. 02-24-2003 11:08 AM #2
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    if there is no : any where other than the values like 16:25, do a global replace with . in the flat file itself...
    Last edited by adewri; 02-24-2003 at 11:10 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  3. 02-24-2003 05:39 PM #3
    LKBrwn_DBA's Avatar
    LKBrwn_DBA
    LKBrwn_DBA is offline Senior Advisor
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,397
    You could also try in your control file:

    ...
    my_nbr position(..) "REPLACE(:my_nbr,':','.')",
    ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width