Keyword and parameter description in pl sql, PL-SQL Programming

Keyword and Parameter Description:

label_name:

This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the double angle brackets and should appear at the beginning of the block. Optionally, label_name can also become visible at the end of the block.

The global identifier declared in an enclosing block can be re-declared in a sub-block, in that case the local declaration prevails and the sub-block cannot reference the global identifier. To reference the global identifier, you should use the block label to qualify the reference, as the illustration below shows:

<>

DECLARE

x INTEGER;

BEGIN

...

DECLARE

x INTEGER;

BEGIN

...

IF x = outer.x THEN -- refers to global x

...

END IF;

END;

END outer;

Posted Date: 10/6/2012 8:51:30 AM | Location : United States







Related Discussions:- Keyword and parameter description in pl sql, Assignment Help, Ask Question on Keyword and parameter description in pl sql, Get Answer, Expert's Help, Keyword and parameter description in pl sql Discussions

Write discussion on Keyword and parameter description in pl sql
Your posts are moderated
Related Questions
Use Bulk Binds If SQL statements execute inside a loop using the collection elements as bind variables, context switching between the PL/SQL & SQL engines can slow down the ex

Using PRIOR and NEXT The PRIOR(n) returns the index number that precede index n in a collection. The NEXT(n) returns the index number which succeed the index n. If n has no pr

Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

Using EXISTS The EXISTS(n) returns TRUE if the nth element in a collection exist. Or else, EXISTS(n) returns FALSE. Primarily, you use EXISTS with DELETE to maintain the spars

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

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

Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

Packaging Cursors   You can split a cursor specification from its body for placement in a package. In that way, you can change the cursor body without changing the cursor spec

Using Cursor Attributes: Every cursor has 4 attributes: %NOTFOUND, %FOUND, %ISOPEN, and %ROWCOUNT. If appended to the cursor name, they return the helpful information about