DevInline - Tech Blog

PL/SQL is a procedural programming language supported by Oracle database server and it is highly integrated with pre existing SQL construct. PL/SQL program unit can be broadly classified in two category :-  Unnamed PL/SQLprogram (Anonymous PL/SQL bl…

In previous post we discussed about  PL/SQL Collections ( Associative array , VARRAY and Nested Tables ) and main agenda of this post is to discuss another composite data structure - Record type in PL/SQL. Record type finds extensive uses when dealin…

In previous post we discussed about implicit & explicit cursor and also understood how it is different from cursor variable.Lets reiterate it again, both explicit cursor and implicit cursor are associated with a specific SQL DML statement(they ar…

Oracle stored procedure is one kind of PL/SQL program unit. Consider the following cases : 1. stored procedure with scalar type - NUMBER, VARCHAR 2. stored procedure with REF CURSOR or SYS_REFCURSOR. What is difference between REF CURSOR and SYS_REF…

It is quite inevitable to do a sincere PL/SQL programming without sound understanding of cursors. The main agenda of this post is to discuss about different types of cursors and its uses in PL/SQL. It is the reference data type of PL/SQL as mentioned …