PLSQL
RDBMS - Cursor Explicit
RDBMS - Cursor Explicit Explicit Cursors: ->programmer defined ->used to fetch d…
PLSQL
RDBMS - Cursor implicit
RDBMS - Cursor implicit Cursors: ->a cursor is a pointer / a reference to some memo…
PLSQL
RDBMS - Exception Handling 1
RDBMS - Exception Handling 1 create a PL/SQL code block that takes empid from the user…
PLSQL
RDBMS - Exception Handling 2
RDBMS - Exception Handling 2 EXCEPTION HANDLING IN PL/SQL Q. create a PL/SQL code bloc…
PLSQL
RDBMS - Function and Stored Procedure
RDBMS - Function and Stored Procedure Functions / Stored Procedures: Function is a gro…
PLSQL
PL/SQL - Array
PL/SQL - Array ARRAYS: ------------- S1: array declaration syntax: TYPE arrayname IS …
PLSQL
PL/SQL - LOOPS
PL/SQL - LOOPS SImple LOOP syntax: LOOP --- --- EXIT WHEN condition; END LOOP; writ…
PLSQL
PL/SQL - PART 1
PL/SQL - PART 1 SET ECHO ON; SET SERVEROUTPUT ON; DECLARE /*Variable declaration*/ n…