on 05-05-2008 1:46 PM
Hi,
I have created data in Oracle DB
and send that from Oracle to File server today
and next day some changes have been made to some records
Now i want to send those Updated Records only to File server
How to acieve this
Regards
Suman
Hi Suman,
you have two possibilities:
a) delete processes records
b) flag records as "processed". For this you need a dedicated field in your DB-table.
Regards Mario
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please check the link
http://wiki.oracle.com/thread/1246329/findrecentmostrowsaddedinatable?t=anon
Here you can find the new inserted data/ modified data from a table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good question ... If the table was not designed to reflect such records (thru a last_changed_date, or has_changed flag etc) it will be hard to get'em
Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.