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 :: Show Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

trunc function in sql loader [message #562843]

Mon, 06 August 2012 05:23

guddu_12
Messages: 124
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

Send a private message to this user

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

Mon, 06 August 2012 05:37

Littlefoot
Messages: 16995
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

Send a private message to this user

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

Mon, 06 August 2012 05:42

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

Senior Member
Account Moderator

DATE_LOADED expression "trunc(SYSDATE)"

Regards
Michel

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

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: Fri May 24 08:08:41 CDT 2013

Total time taken to generate the page: 0.08092 seconds