Equivalent to ON DELETE CASCADE using UPDATE in ORACLE

greenspun.com : LUSENET : DBAzine : One Thread

hi,

i want to replicate a column,,for example there r 2 tables emp and dept ,,and from dept instead of taking dept_id as a foreign key into emp table,,i am taking dept_name as a foreign key into emp(first i created a unique constraint on dept_name in dept table),,so i think iam replicating the column,,,now plz tell me is it called a replication of column,,if not then plz tell me the right way / procedure to replicate the column,,, my 2nd question is tht,, after i brought dept_name column in emp ,,now when i wanna change dept_name in dept table ,,it will'nt allow me to do as a simple integrity constraint is violated,,as we can create a foreign key with ON DELETE CASCADE ,,is there any equivalent for updating purposes??

regards umar

-- Muhammad Umar Liaquat (zindadil7t8@yahoo.com), June 19, 2004


Moderation questions? read the FAQ