-
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
)
-
You ccan apply sqlfunctions to data during the load -- see utilities guide for examples
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
|