var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: delete from multiple tables
I'm new to oracle. I have three tables. I want to delete any record(s) from these three tables where user_id = 98
How can I do this in oracle?
Would this work??
delete from table1, table2, table3 where title_id = 98
if title_id is a candidate for a primary key in table 1,
create foreign keys with cascade delete on table 2 and table 3
referencing title_id in table 1...
Delete from table 1 where title_id = 'xxx';
Rows in table 2 and table 3 will also be deleted...
Another option ...
delete trigger on table 1 for each row
delete from table 2 where title_id = ld.title_id
delete from table 3 where title_id = ld.title_id