Monday, 16 January 2017
PL/SQL Cursors For Loop
PL/SQL cursor FOR loop has one great advantage of loop continued until row not found. In sometime you require to use...
Friday, 6 January 2017
PL/SQL Explicit Cursor
Explicit Cursor which are construct/manage by user itself call explicit cursor. User itself to declare the cursor, open cursor to reserve...
PL/SQL Implicit Cursor
Oracle uses implicit cursors for its internal processing. Even if we execute a SELECT statement or DML statement Oracle reserves a...
PL/SQL Cursors (Implicit, Explicit, For Loop, Parameterized Cursor)
What is Cursor? Cursor is the work area which Oracle reserves for internal processing of SQL statements. This work area is...
PL/SQL Case Statement
PL/SQL CASE statement comparing one by one sequencing conditions. CASE statement attempt to match expression that is specified in one or...
PL/SQL EXIT CONTINUE GOTO Statements
PL/SQL EXIT, CONTINUE, GOTO Statements (Sequential Control Statements) are control your iteration loop, This three statement are sequential control statement, EXIT...
