OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL-LOADER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL-LOADER [message #228605]

Tue, 03 April 2007 08:08

rudorathod
Messages: 14
Registered: October 2006

Junior Member

I have a table with following fields

create table abc
( col1 varchar2(5),
col2 varchar2(5),
col3 varchar2(5));

i want to load use the sql loader utility to load data into "abc" table

load data
infile *
append
into table abc
( col1 position(1:5) ":col1||":"||:col4",
col2 position(6:10),
col3 position(11:15),
col4 position(16:20)
)
BEGINDATA
ABCDEMNOPQFGHIJXXXXX

finally when I load the table
I want data to to be loaded in this manner

select * from abc;

col1
ABCDE:XXXXX

col2
MNOPQ

col3
FGHIJ

so in other words, we don't have col4 as a field in the table, but we want sqlloader to read as a temp field in the table just so that we can use it to concatinate the data with other fields

Is it possible

Report message to a moderator