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
Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

How Exceptions Propagate ? Whenever an exception is raised, and if the PL/SQL cannot find a handler for it in the present subprogram or block, the exception propagates. That is

Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illus

Majority of Differences among 9i, 10G, 11G :- These are some combine feature which has differences among others. Automatic Workload Repository (AWR) Drop database' s

Anatomy of a Table: Figure shows the terminology used in SQL to refer to parts of the structure of a table. As you can see, SQL has no official terms for its counterpa

Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot

Need Windows and Linux system Administrator We are seeking a part time system administrator to take care of our servers. Your things to do would add, but not limited to: -

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