OraFAQ Forum: Server Utilities » trunc function in sql loader

Home » RDBMS Server » Server Utilities » trunc function in sql loader (oracle 11gr2 solaris 10)

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

trunc function in sql loader [message #562843]

Mon, 06 August 2012 05:23

guddu_12
Messages: 223
Registered: April 2012
Location: UK

Senior Member

Hi ,

I am using trunc(sysdate) to load only date in a column and it is coming out with error.
SQL*Loader-350: Syntax error at line 44.
Expecting valid column specification, "," or ")", found "trunc".
DATE_LOADED trunc(SYSDATE)

How can i acive this.

Thanks

Report message to a moderator

Re: trunc function in sql loader [message #562847 is a reply to message #562843]

Mon, 06 August 2012 05:37

Littlefoot
Messages: 21756
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Double quotes!

date_loaded "trunc(sysdate)"

P.S. By the way, it is described in documentation: Applying SQL Operators to Fields.

[Updated on: Mon, 06 August 2012 05:39]

Report message to a moderator

Re: trunc function in sql loader [message #562849 is a reply to message #562843]

Mon, 06 August 2012 05:42

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

Senior Member
Account Moderator

DATE_LOADED expression "trunc(SYSDATE)"

Regards
Michel

Report message to a moderator

Previous Topic:	Exporting schema using consistent parameter
Next Topic:	Exporting schema using filesize parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 29 14:07:48 CST 2023