Home » RDBMS Server » Server Utilities » trunc function in sql loader (oracle 11gr2 solaris 10)
trunc function in sql loader [message #562843] Mon, 06 August 2012 05:23 Go to next message
guddu_12
Messages: 172
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
Re: trunc function in sql loader [message #562847 is a reply to message #562843] Mon, 06 August 2012 05:37 Go to previous messageGo to next message
Littlefoot
Messages: 19346
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 Go to previous message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DATE_LOADED expression "trunc(SYSDATE)"

Regards
Michel

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


Current Time: Fri Aug 01 03:42:34 CDT 2014

Total time taken to generate the page: 0.16294 seconds