PL/SQL program unit - Stored Procedure and Function
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 Record Type - a composite data structure
In previous post we discussed about PL/SQL Collections ( Associative array , VARRAY and Nested Tables ) and main agenda of this post is to...Read More
PL/SQL Cursor variable - REF CURSOR
In previous post we discussed about implicit & explicit cursor and also understood how it is different from cursor variable.Lets reiter...Read More
How to test a oracle stored procedure with ref cursor from SQL*PLUS or SQL Developer
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
PL/SQL Cursor - Explicit and Implicit cursor, Cursor variable
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
Subscribe to:
Posts
(
Atom
)
