-
I have a file stored somewhere (let's say under D:/oracle/bin). This file contains some records separated by a delimiter.
Let's say the file contains:
11|name1|a
22|name2|b
33|name3|c
I want to read the file get the values and insert it into a table where I have three columns namely id, name and code.
-
use SQL LOADER. this is sample
LOAD DATA
CHARACTERSET WE8MSWIN1252
INFILE '/d:\oracle\bin\file_name.txt'
READBUFFERS 4
TRUNCATE
INTO TABLE table_name
REENABLE DISABLED_CONSTRAINTS
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
( fld_1 INTEGER EXTERNAL
, fld_2 CHAR
, fld_3 CHAR
)
-
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
|