OraFAQ Forum: Server Utilities » A DATE datatype question (SQL*Loader)

Home » RDBMS Server » Server Utilities » A DATE datatype question (SQL*Loader)

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

A DATE datatype question (SQL*Loader) [message #474241]

Fri, 03 September 2010 16:53

lpimentel
Messages: 10
Registered: September 2010

Junior Member

may I use ??

trunc(sysdate,'DD')

EDITED by LF: Message split from a hijacked topic. As it is not quite clear what it is about, I "created" a dummy title (which might be modified once we find out what the problem is).

[Updated on: Sat, 04 September 2010 04:01] by Moderator

Report message to a moderator

Re: insert only date using sqlldr [message #474255 is a reply to message #474241]

Sat, 04 September 2010 01:56

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

To achieve what?

Regards
Michel

Report message to a moderator

Re: insert only date using sqlldr [message #474513 is a reply to message #474255]

Mon, 06 September 2010 15:44

lpimentel
Messages: 10
Registered: September 2010

Junior Member

Hi Michel !

I'm trying to load data using Oracle Loader
as below and it shows an error.
Do you correct syntax ?
tks.

SQL*Loader-350: Syntax error at line 18.
Expecting "," or ")", found " TRUNC ".
LAST_UPDATE TRUNC(SYSDATE, 'DD')

CTL:

OPTIONS (SKIP=1,SILENT=(HEADER, FEEDBACK))
LOAD DATA
APPEND
INTO TABLE GL_BALANCE_SHEET
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' AND '"'
TRAILING NULLCOLS
(
PARTITION_KEY CHAR(12),
COMPANY_CODE CHAR(12),
GL_ACCOUNT_CODE CHAR(50),
CURRENCY_CODE CHAR(3),
BALANCE ,
DEBIT_CREDIT CHAR(1),
AMOUNT_1 ,
AMOUNT_2 ,
GAAP_CODE CHAR(12),
IMPORT_SOURCE CHAR(20),
LAST_UPDATE trunc(sysdate,'DD')

)

Report message to a moderator