Delete Truncate and Drop -Learn basic differences between Delete Truncate and Drop commands with examples. DELETE TRUNCATE DROP DML command DDL command DDL command Need
Category: Oracle PL SQL
Oracle PL SQL Tutorial Examples and Queries.
SQL Merge statement – Learn how to insert, delete and update the records into the table using single statement. MERGE-statement made for situations when you want
Oracle Unique constraint vs Unique Index- Learn about unique constraint and unique index creation and their difference with example programs. For brief discussion about unique
Instead of Triggers -Learn how when to use instead of Triggers with programming Example. When you are not allowed modify a view directly then you
Complex Views – Learn how to create complex views , when can we update views and when we cannot update views with example Programs. Complex
SQL Sub Languages-Learn about types of statements used in SQL and their classification with explanation. SQL consists of many type of statements, which classified as
PL-SQL Transactions – Learn how to preserve data integrity with COMMIT, ROLLBACK , SAVEPOINT statements in transaction management. Also Learn in which situations COMMIT, ROLLBACK ,
DISABLE ENABLE and DROP TRIGGERS – Learn how to disable and enable trigger on a table with examples. Also Learn how to remove a triggers
Before Delete and After Delete Triggers–Learn how to use Before and After Delete Triggers with Examples. Before Delete and After Delete Triggers BEFORE DELETE TRIGGER
Before Update and After Update Triggers-Learn how to use Before and After Update Triggers with Examples. BEFORE UPDATE TRIGGER The Before UPDATE Trigger is fired