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

Ask an Expert

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

Write your message here..

Related Questions

Using rename in combination with join - sql, Using RENAME in combination wi... Using RENAME in combination with JOIN - SQL Example gives pairs of ids of students having the same name, by joining two renamings of IS_CALLED. Example gives an equivalent ex

Read-only operator (+) - sql, Read-Only Operator (+) - SQL The term r... Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Subprograms, What Are Subprograms? The Subprograms are named PL/SQL blo... What Are Subprograms? The Subprograms are named PL/SQL blocks which can take parameters and be invoked. The PL/SQL has 2 types of subprograms known as the procedure s and func

Update stock levels, At times, customers make mistakes in submitting their ... At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean's wants to create a trigger that automatically updates the stock level of all pr

What are decision support systems, (a) What are decision support systems, a... (a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c

Example of when or then constraints - sql, Example of WHEN or THEN Constrai... Example of WHEN or THEN Constraints A concrete example showing how SQL supports WHEN/THEN constraints CREATE TABLE SAL_HISTORY (EmpNo CHAR (6), Salary INTEGER NOT NULL,

Calculating a Shopper''s Total Spending, Many of the reports generated from... Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp

Using forall statement - bulk bind performance improvement, Using the FORAL... Using the FORALL Statement The keyword FORALL instruct the PL/SQL engine to bulk-bind input collections before sending them all to the SQL engine. Though the FORALL statement

Keyword and parameter description - delete statement, Keyword and Parameter... Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must

Keyword & parameter description - exception_init pragma, Keyword & Paramete... 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