| data need to wrap in one line. [message #57287] |
Mon, 02 June 2003 15:09  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
|
i have a data file which stores a record in 2 lines, and i need to wrap into one line, how do i do that. like say if a record got 6 fileds, then 4 fields data is stored in one line and and other 2 fields data stored in next line. i need to make it into one line, so that i can use sqlloader, i need to do this using unix or pl/sql how? please help me out
|
|
|
|
| Re: data need to wrap in one line. [message #57289 is a reply to message #57287] |
Mon, 02 June 2003 17:10  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
you can do it with sql*loader itself.
depends on format of your datafile (delimiters etc).
look into oracle utilities manual ( from anysite, technet.oracle.com/docs or tahiti.oracle.com)
look for 'STREAM LINE FORMAT' topic.
depending on the need, u can use MANY BUILT-IN FUNCTIONALITIES LIKE concatenate,conitinueif, continueif last etc.
Please post a sample of your datafile, structure of table
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
