-
What is a stored procedure ?
A stored procedure is a sequence of statements that perform specific function.
g_sidhu
- Jan 31st, 2008
A procedure is a named PL/SQL block that can accept parameters (sometimes referred to as arguments), and be invoked. Generally speaking, you use a procedure to perform an action. A procedure has ...
ramesh_resides
- Jun 23rd, 2007
Stored procedure is a sub program and stored in memory for repated execution
-
What is the basic structure of PL/SQL ?
PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.
g_sidhu
- Feb 16th, 2008
PL/SQL is a block-structured language, meaning that programs can be divided into logical blocks. A PL/SQL block consists of up to three sections: declarative (optional), executable (required), and exception handling (optional).
Me
- Oct 5th, 2007
DeclarationBeginException HandlingEnd
