Declare keyword description in pl sql, PL-SQL Programming

DECLARE:

This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the present block and all its sub-blocks and are not noticeable to enclosing blocks. The declarative section of the PL/SQL block is optional. It is terminated implicitly by using the keyword BEGIN that introduces the executable section of the block.

The PL/SQL does not allow the forward references. Therefore, you should declare an item before referencing it in other statements, including the other declarative statements. You should also declare the subprograms at the end of a declarative part after all other program items.

collection_declaration:

These identify an index-by table, nested table, or varray previously declared within the present scope.

constant_declaration:

A constant can be declared by using this construct.

cursor_declaration:

These constructs declares an explicit cursor

cursor_variable_declaration

These construct declares the cursor variable.

exception_declaration

These construct declares an exception.

object_declaration

These identify an object (or instance of an object type) formerly declared within the present scope. 

Posted Date: 10/6/2012 8:54:58 AM | Location : United States







Related Discussions:- Declare keyword description in pl sql, Assignment Help, Ask Question on Declare keyword description in pl sql, Get Answer, Expert's Help, Declare keyword description in pl sql Discussions

Write discussion on Declare keyword description in pl sql
Your posts are moderated
Related Questions
Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

Using FIRST and LAST FIRST and LAST return the first and last (minimum and maximum) index numbers in a collection. When the collection is empty, the FIRST and LAST return NULL

Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi

Table Represents an Extension - SQL It describes how each tuple in a relation represents a true instantiation of some predicate and each true instantiation is represented by s

Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM

Using Aliases The Select-list items fetched from a cursor related with the %ROWTYPE should have simple names or, if they are expressions, should have aliases. In the example bel

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

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

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca