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
Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

ORIGIN OF EARTH - BIG-BAN G HYPOTHESIS - Origin of life is linked to origin of earth. Cosmos, the Universe originated 10-20 billion years ago by Big Bang (thermonu

Application to Export Excel Data to MSSQL Server table I am having a table available in excel format and features the subsequent: - Some text is in Arabic (e.g. UTF-8 encodin

Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope

Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

INSERT Command in SQL Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the targ

Question: (a) The objective of query optimization is to choose the most efficient strategy for implementing a given relational query, thereby improving the system performance. On

Challenge 1 You are required to do the project and write a test plan for it. Demo 4 is a check writer program for employees. In it, the user enters all information about the

set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d