-
Sqlloader , validate data before load
Hello everybody,
some application generates ASCII-Files
like monday.dat, tuesday.dat etc.
I would like to load data form this tables
into a table in Oracle using following validation rules:
If a record already exists in the table then skip it.
If a record has been updated on Monday evening - update it in the table.
If a record doesn't exist - insert it.
Hope you understand what I mean
Thanks in advance.
WinNT, Oracle 8.1.7
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|