Declaring subprograms, PL-SQL Programming

Declaring Subprograms 

You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after all the other program items. For illustration, the procedure declaration below is misplaced:

DECLARE

PROCEDURE award_bonus (...) IS -- misplaced; must come last

BEGIN

...

END;

rating NUMBER;

CURSOR c1 IS SELECT * FROM emp;

Posted Date: 10/5/2012 5:25:25 AM | Location : United States







Related Discussions:- Declaring subprograms, Assignment Help, Ask Question on Declaring subprograms, Get Answer, Expert's Help, Declaring subprograms Discussions

Write discussion on Declaring subprograms
Your posts are moderated
Related Questions
Semidifference and NOT - SQL In this section first describe the relational difference operator, named MINUS. Example here shows SQL's closest counterpart of that operator.

UPDATE Command- SQL Loosely speaking, UPDATE changes some of the column values of some existing rows of its target table. Thus, although some rows disappear from the target an

Create a Oracle procedure to produce vertical output format when selecting rows from a database table.

Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

I need SQL , WP SQL Expert Project Description: Expert required to modify WP SQL query. Skills required are MySQL, SQL, PHP, Wordpress

Recursive Subprograms The recursive subprogram is the one that calls itself. Think of a recursive call as a call to a few other subprograms that does the similar task as your

Equivalences & Rewrite Rules: If notice that as well as allowing us to prove trivial theorems, and tautologies enable us to establish that certain sentences are saying the sam

%ISOPEN The Oracle closes the SQL cursor automatically after executing its related SQL statement. As a result, the %ISOPEN forever yields FALSE.

I need to write one function and one procedure to query a Oracle 10.1 DB using PL SQL. I have the schema and exact queries...along with work Ive started and a template to put the a

Project Description: We organize an online system called ACPAS we have created a project called EVO that can be use by our customers to integrate their web sites with the Acpas