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
Second Step at defining type SID in SQL CREATE TYPE SID AS VARCHAR(5) ; Explanation: TYPE SID announces that a type named SID is being defined to the system.

Subprograms The PL/SQL has two types of subprograms known as the procedures and functions that can take parameters and be invoked. As the following example represents, a subp

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

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Using Operator VALUE: As you may expect, the operator VALUE returns the value of an object. The VALUE takes its argument a correlation variable.  For illustration, to return a

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

IN Mode An IN parameter pass the values to the subprogram being called. Within the subprogram, an IN parameter acts like a constant. And hence, it cannot be assigned a value.

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

Redeclaring Predefined Exceptions Keep in mind that, the PL/SQL declares predefined exceptions globally in the package STANDARD; Therefore you need not declare them yourself.

Inserting Objects: You can use the INSERT statement to add objects to an object table. In the illustration below, you insert a Person object into the object table persons: