Delete Table

Question

Hi My question is about the sql -: If Delete Any Table In Back-End Then. Thanks

Satyapriya Nayak · Answer

Hi Arjun 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 BEFORE DROP OR TRUNCATE ON SCHEMA In oracle two triggers work when any DML command execute one for insert and other for delete.SoWhen 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