Category: Oracle PL SQL

Learn if else in PL SQL and more conditional statements used in Oracle viz if-then-end if | if-then-else-end if | if-then-elseif-endif | Nested if statements

In PL/SQL debugging statement is used to display output or print the message.  DBMS_OUTPUT.PUT_LINE is used to display the message in fact. DBMS_OUTPUT is a built

Learn PL SQL variables, its declaration and types etc with examples. In PL/SQLvariables are used to store data temporarily  for calculations and data manipulations without

Before and After Insert Triggers -Learn how to use Before and After Insert Triggers with Examples. Before and After Insert Triggers BEFORE INSERT TRIGGER The

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

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