OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » sqlldr question

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

sqlldr question [message #72791]

Mon, 20 October 2003 16:35

Mayer Ziegler
Messages: 1
Registered: October 2003

Junior Member

I have a file that contains data with yesterday's date and today's date. How can I use sqlldr to only load the data with today's date?

I tried WHEN DT = TRUNC(SYSDATE) and got an error Expecting quoted string or hex identifier, found "TRUNC".

Report message to a moderator

Re: sqlldr question [message #72792 is a reply to message #72791]

Tue, 21 October 2003 01:39

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

simplest method is to
1. craete another table like the target table
2. write an after insert  trigger in another_table which will , load data into target_table where inserted record is trunc(sysdate) or whatever your business need is.
3. load data from flat file into your another_table as is...

Report message to a moderator

Previous Topic:	Backup table
Next Topic:	database sync

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 12:44:10 CDT 2024