Home » RDBMS Server » Server Utilities » Terminators and datafile of sql loader (oracle 10.2.0.1.0 - windows XP)
Terminators and datafile of sql loader [message #491075] Fri, 28 January 2011 23:23 Go to next message
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 #491076 is a reply to message #491075] Fri, 28 January 2011 23:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
>eg - '|' - this shows error.
ERROR? What error? I don't see any error.

>What are the file format can be used in DATAFILE other than txt file.
Leave the Windoze world & you won't be hobbled by any such artificial limitations.
Re: Terminators and datafile of sql loader [message #491082 is a reply to message #491075] Sat, 29 January 2011 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Any but chr(0) (or '\0' as you want depending of your culture)
2) None, only plain text file is allowed

Have a look at SQL*Loader, at least first chapter "SQL*Loader Concepts".

Regards
Michel
Re: Terminators and datafile of sql loader [message #492345 is a reply to message #491075] Sat, 29 January 2011 14:23 Go to previous message
Barbara Boehmer
Messages: 9077
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.




Previous Topic: SQL LOADER
Next Topic: Statspack report in windows and linux
Goto Forum:
  


Current Time: Fri Mar 29 01:03:05 CDT 2024