PL/SQL is a procedural programming language supported by Oracle database server and it is highly integrated with pre existing SQL construct....Read More
PL/SQL program unit - Stored Procedure and Function
Reviewed by Nikhil Ranjan
on
September 26, 2015
Rating: 5
Oracle stored procedure is one kind of PL/SQL program unit. Consider the following cases : 1. stored procedure with scalar type - NUMBER, V...Read More
How to test a oracle stored procedure with ref cursor from SQL*PLUS or SQL Developer
Reviewed by Nikhil Ranjan
on
September 25, 2015
Rating: 5
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...Read More
PL/SQL Cursor - Explicit and Implicit cursor, Cursor variable
Reviewed by Nikhil Ranjan
on
September 23, 2015
Rating: 5