Home » RDBMS Server » Server Utilities » SQL-LOADER
SQL-LOADER [message #228605] Tue, 03 April 2007 08:08 Go to next message
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
Re: SQL-LOADER [message #228634 is a reply to message #228605] Tue, 03 April 2007 09:31 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/170602/0/?srch=boundfiller#msg_170602
Previous Topic: How Can I Accumulate data from several .dmp files
Next Topic: Export Table to free space in Production Database
Goto Forum:
  


Current Time: Sun Dec 04 20:42:58 CST 2016

Total time taken to generate the page: 0.07846 seconds