| deleting records [message #332210] |
Mon, 07 July 2008 21:43  |
caprikar
Messages: 226
Registered: March 2007
|
Senior Member |
|
|
Hi,
I have 10 tables in which i want to schedule a job that will delete records from all the 10 tables based on one condition.
Say, select cnt_id, per_id from table A
where user_id=x and country_id=y;
Now, I have to delete table 1 to table 10 based on cnt_id and per_id selected from the above query.
Is it a good ideal to run a job that deletes from all the 10 tables everyday or is there anyother way that i can do this?
|
|
|
|
|
|
| Re: deleting records [message #332803 is a reply to message #332210] |
Wed, 09 July 2008 14:46  |
JackyShu
Messages: 25
Registered: May 2008
|
Junior Member |
|
|
Oracle doesn't support mutliple table delete, some open source db like mysql supports it.
if tables are parent table and children tables, then you can use delete cascade.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
