Home » RDBMS Server » Server Utilities » merge fileds
merge fileds [message #73528] Mon, 17 May 2004 04:32 Go to next message
akif güngör
Messages: 4
Registered: April 2004
Junior Member
i have this ascii file:

field1&#124field2&#124field3&#124field4

1020&#124COMPANY&#124USA&#124LA

54132&#124SCHOOL&#124EUROPA&#124LONDRA

5464&#124GOVERN&#124ASIA&#124ISTANBUL

my table

create table deneme

(

o_field1 NUMBER(20),

o_field2 VARCHAR2(20)

)

i want to insert  field1 and field3 same column and field2 and field4 same column to my table.i mean:

SQL> select * from my_table;

o_field1                     o_field2

________                  _________

1020 USA                 COMPANY LA

54132 EUROPA        SCHOOL LONDRA

5464 ASIA                GOVERN ISTANBUL

how do i must write control file.

thanks, sorry my english.

Report message to a moderator

Re: merge fileds [message #73532 is a reply to message #73528] Mon, 17 May 2004 23:21 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
You can simply create a Temporary table with Cols Field1,2 3 & 4 & load data into it.
Then from Temp table populate your table as follows:

Insert into my table values(Feild1||feild2,Feild3||feild4);

Regards
Himanshu

Report message to a moderator

Re: merge fileds [message #73543 is a reply to message #73532] Wed, 19 May 2004 06:44 Go to previous message
akif güngör
Messages: 4
Registered: April 2004
Junior Member
thanks,
but my datafiles are very big,
each of my datafiles is between 100 MB and 400 MB.
it is not effective

Report message to a moderator

Previous Topic: I need help - IMP 00069
Next Topic: sqlnet.ora,tnsname.ora etc
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 15:56:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.