Home » RDBMS Server » Server Utilities » SQL LOADER : How to specify sysdate with infile name?
SQL LOADER : How to specify sysdate with infile name? [message #252843] Fri, 20 July 2007 04:25 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Roll BAck during SQL*LOADER execution
Next Topic: SQL Loader control file to create duplicate row
Goto Forum:
  


Current Time: Sun Dec 04 12:49:33 CST 2016

Total time taken to generate the page: 0.10430 seconds