Hi,
My question is about the sql -:
If Delete Any Table In Back-End Then.
Thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Jan 22, 2012, 7:24 AM
Triggers are fired in the Back-End.
Oracle has Schema triggers (CREATE OR REPLACE TRIGGER ... ON SCHEMA ... that will file on DDL commands.
CREATE OR REPLACE TRIGGER save_our_db
In oracle, two triggers work when any DML command execute one for insertBEFORE DROP OR TRUNCATE
ON SCHEMA
and other for delete.So,When we delete any table , it's rows first being entered in temporary table of insert trigger and then be deleted.This is how the oracle server shows the contents of table when it rollback by user.
Thanks