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
Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl

query to Find the account numbers of all customers whose balance is more than 10,000 $

Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta

Use Serially Reusable Packages To help you to manage the use of memory, the PL/SQL gives the pragma SERIALLY_ REUSABLE that mark some packages as serially reusable . So mark

The Package Body The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the p

Keyword and Parameter Description: boolean_expression: This is an expression which results the Boolean value TRUE, FALSE, & NULL. It is related with a series of statement

DBMS: The answer to this question is of course given in of the theory book. This book is concerned with SQL DBMSs and SQL databases in particular. Soon we will be looking a

GOTO Statement The GOTO statement branches to a label unconditionally. The label must be exclusive within its scope and should precede an executable statement or a PL/SQL block.