Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_DATE_FORMAT and SQL Loader
Exporting with sqlldr? sqlldr is for loading not for exporting. News to me if you can do that with it. Generally, if your exporting data to a flat file, you can just use the utl_file parameter to set up a dump area, and then use pl/sql for the extract. Since your using code, use a to_char function with whatever format string you want.
On Thu, 01 Jun 2000 19:32:03 GMT, christopher.lewis_at_ac.com wrote:
>Hi all,
>I'm trying to export data to a flat file using a sqlldr script, however
>the date fields get exported without the time stamp. I know I need to
>change the NLS_DATE_FORMAT, I'm just not sure of the best place to do
>it. I've tried adding an alter session command within the UNIX shell
>script I'm using that calls SQLPlus to do the export, but this doesn't
>seem to work. I've also tried adding it as an environment variable, but
>this doesn't seem to help either... I'd rather not have to change
>the init.ora file or add an alter session statement within a db logon
>trigger... Any suggestions? Thanks!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Jun 02 2000 - 00:00:00 CDT