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
This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

Creating a SQL file 1. Open a new file in Notepad++ and save it to the location c:\mysql\bin, with the name lab8script.sql (the file extension should be .sql ). Add a MySQL co

Data Types in SQL - Timestamp TIMESTAMP for values representing points in time on a specified uniform scale. DATE is used for timestamps on a scale of one day, such as DATE '2

Effects of NULL in Table Literal When a VALUES expression appears as the source value for an SQL INSERT statement, the key word NULL can appear as a field value, such that for

IS NULL Operator The IS NULL operator returns the Boolean value TRUE whenever its operand is null or FALSE if it is not null. The comparisons including the nulls always yield NU

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n

SQL Functions The PL/SQL uses all the SQL functions involving the following aggregate functions that summarize the whole columns of the Oracle data: GROUPING, AVG, COUNT, STDDE

An analyst in the quality assurance office reviews the time lapse between receiving an order and shipping an order. Any orders that have not been shipped within a day of the order

MAX and MIN operator in SQL Example: (SELECT MAX (Mark) FROM EXAM_MARK WHERE StudentId = 'S1') (SELECT MIN (Mark) FROM EXAM_MARK WHERE StudentId = 'S1') Example