Category: Oracle PL SQL

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

PL/SQL BLOCKS Learn about PL/SQL Blocks, Structure and Syntax with examples including Nested Block and Anonymous Block in Oracle Data base. PL/SQL block is a

ORACLE-SEQUENCES – Learn how to Generate sequence integers, and Also Learn how to use this sequence integer numbers for Primary key and Unique keys column

Database triggers – Learn when and how trigger works on database tables. Also Learn their classification and usage in different scenarios with examples Database Triggers

PL-SQL Nested Tables -Learn how to use Nested tables in PL-SQL. Also learn the similarities and difference between Index By Table, VARRAY, Nested Tables with

PL-SQL Tables- Learn the implementation difference between arrays and PL-SQL Tables with syntax and examples. Also Learn about some predefined Collection Methods used in collections

PL-SQL Programmer defined Records-Learn about Programmer-defined Record declaration , Also Learn how same it is with other languages like C and C# structure related concepts.