dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

how to set up a "delete inhibit" in creating a table? - Oracle Errors

This is a discussion on how to set up a "delete inhibit" in creating a table? - Oracle Errors ; As we can't use a trigger to cancel a delete but we could change the table to inno, create a second table that identifies rows we want to "delete inhibit", then use foreign keys to DELETE RESTRICT the row. But ...


Home > Database Forum > Oracle Database > Oracle Errors > how to set up a "delete inhibit" in creating a table?

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 03-15-2009, 02:01 PM
Database Newbie
  
Join Date: Mar 2009
Posts: 1
joe2278567 is on a distinguished road
Default how to set up a "delete inhibit" in creating a table?
As we can't use a trigger to cancel a delete but we could change the table to inno, create a second table that identifies rows we want to "delete inhibit", then use foreign keys to DELETE RESTRICT the row.

But i want to know how to set up a "delete inhibit" in creating a table in an Oracle database(use PL/SQL)? Many thanks!
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode



All times are GMT -4. The time now is 09:26 AM.