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
Usefulness of Data Type In SQL, as in most computer languages, a type can be used for constraining the values that are permitted to be used for some purpose. In particular, i

OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a

Lightweight system to provide and take info from workers in the field and office, have basic design outlined already just require build and implementation Desired Skills CSS,

Number Types The Number types permit you to store the numeric data (real numbers, integers, and floating-point numbers), show quantities, and do computations. BINARY_INTEG

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

UNION without CORRESPONDING - SQL The use of UNION without CORRESPONDING. Example is merely by omitting CORRESPONDING, but only because the operands have identical SELECT clau

First Step at defining type SID in SQL CREATE TYPE SID AS ( C VARCHAR(5) ) ; Explanation: TYPE SID announces that a type named SID is being defined to the syst

Explicitly specifying the join condition - SQL SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON ON ( IS_CALLED.StudentId = IS_ENROLLED_ON.StudentId ) Now, the key word JO

Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment