| Terminators and datafile of sql loader [message #491075] |
Fri, 28 January 2011 23:23  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi All,
please guide me on the below query:
1) What are the terminators we can use and cant be used, except ','.
eg - '|' - this shows error.
2) What are the file format can be used in DATAFILE other than txt file.
Eg - excel, word...
And how to terminate the values in that files...
Regards:
Muktha
|
|
|
|
|
|
|
|
| Re: Terminators and datafile of sql loader [message #492345 is a reply to message #491075] |
Sat, 29 January 2011 14:23  |
 |
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
muktha_22 wrote on Fri, 28 January 2011 21:23
1) What are the terminators we can use and cant be used, except ','.
eg - '|' - this shows error.
You can use , or | or any other characters or combinations of characters, like:
terminated by 'abc'
or whitespace (spaces, tabs, blanks, line feeds, form feeds, or
carriage returns)
You can also use "optionally enclosed by" with "terminate by".
muktha_22 wrote on Fri, 28 January 2011 21:23
2) What are the file format can be used in DATAFILE other than txt file.
Eg - excel, word...
And how to terminate the values in that files...
For SQL*Loader only text files, but you can use Oracle Text to access other formats, such as doc and pdf and convert them to a text document or index and search the data in them.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
