OraFAQ Forum: Server Utilities » Need a solution for the next sqlloader action

Home » RDBMS Server » Server Utilities » Need a solution for the next sqlloader action

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

Need a solution for the next sqlloader action [message #182322]

Fri, 14 July 2006 05:45

magnetic
Messages: 324
Registered: January 2003

Senior Member

Hi,

The next sqlloader challenge for you:

i have a tabel with columns : id number, c1 varchar2.
datafile contains data like:

<A>abc</A><B>abcdef </B><C>xy</C>.......

Desired output in oracle:
id c1
-----------------
1 <A>abc
2 </A>
3 <B>abcde
4 </B>
5 <C>xy
6 </C>

Id has been filled with a sequence. What i want is that each record of column c1 starts with the sign "<".

Pratically the datafile contains too many data per row wich gives a linebuffer exceed error, otherwise i could insert the whole string in oracle and could try to resolve it with plsql.

I need a controlfile wich can achive what i want.

control file should look like:
LOAD DATA
REPLACE
INTO T1
(id "T1_seq.nextval"
,c1 ???)

Could anyone come with a solution for this problem?

Thanks.

magnetic.

Report message to a moderator