OraFAQ Forum: Server Utilities » SQL LOADER : How to specify sysdate with infile name?

Home » RDBMS Server » Server Utilities » SQL LOADER : How to specify sysdate with infile name?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL LOADER : How to specify sysdate with infile name? [message #252843]

Fri, 20 July 2007 04:25

fortunethiyagu
Messages: 94
Registered: December 2006

Member

Hi,

How to specify sysdate with infile name?

load data
infile "to_char(sysdate,'yymmdd')||'.txt''
into build_te
fields terminated by "," optionally enclosed by '"'
(a,
 b,
 c
)

infile " to_char(sysdate,'yymmdd')||'.txt' ''
Is this correct?

-thiyagu

[Updated on: Fri, 20 July 2007 04:28]

Report message to a moderator

Re: SQL LOADER : How to specify sysdate with infile name? [message #252885 is a reply to message #252843]

Fri, 20 July 2007 08:31

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Is this correct?

No you can't do this.

You should use external table instead of SQL*Loader, you can then give the infile name with SQL.
Otherwise, you have to dynamically modify the control file in your shell script that launches SQL*Loader.

Regards
Michel

Report message to a moderator

Previous Topic:	Roll BAck during SQL*LOADER execution
Next Topic:	SQL Loader control file to create duplicate row

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 21:43:09 CDT 2024