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
SQLs counterpart of the key words: The text from the opening parenthesis to the end of the fourth line specifies the declared type of the table, meaning that every table ever

Fetching with a Cursor The FETCH statements retrieve the rows in the result set one at a time. After each and every fetch, the cursor advance to the next row in the result set

Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Change Sql file into CSV for product registration on Magento Project Description: I have a set of files that are in Sql format and could like for a developer to help me with

Character Types The Character types allow you to store alphanumeric data, represent words and text, and manipulate the character strings. CHAR You use the CHAR dataty

Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

User-Defined Exceptions The PL/SQL defines the exceptions of your own. Dissimilar to the predefined exceptions, the user-defined exceptions should be declared and should be rai

Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF