sqlloader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sqlloader

  1. #1
    Join Date
    Sep 2003
    Posts
    49

    sqlloader

    iam trying load the data from text file.
    Data text file look like this...
    00100| |H|H174|.001MF/2KV | | | |DISC CAP
    00100| |A|A143|.01MF100V | | | |P/N C4-100V / .01UF
    00100| |A|A40 |.033MF | | | |P/N 22804918 **T/S

    Third column is number datatype in oracle db. i want to suppress first alphabetic character and load the remaining number data. is there any function to load the number data.

    My ctl look like this

    OPTIONS (BINDSIZE=1024000)
    LOAD DATA
    INFILE 'd:\data\fr-parts-record_ldr.dat'
    INTO TABLE f_parts_record
    REPLACE
    FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '+++'
    TRAILING NULLCOLS
    (
    LOCATION_NO,
    SITE_LOCATION,
    BIN_NUMBER COLUMN OBJECT
    (
    BIN_A,
    BIN_B
    ),
    PART_NUMBER,
    PART_TYPE,
    SUB_TYPE,
    SUB_PTNUM,
    PART_DESCRIPTIOn
    )

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You ccan apply sqlfunctions to data during the load -- see utilities guide for examples
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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