Blocks:

The fundamental program unit in the PL/SQL is the block. The PL/SQL block is defined by the keywords BEGIN, DECLARE, EXCEPTION, and END. These keywords partition the block into the declarative section, an executable section, & an exception-handling section. Only the executable section is needed. You can nest the block within the other block wherever you can place an executable statement.

Syntax:

Posted Date: 10/6/2012 8:50:13 AM | Location : United States

Ask an Expert

Related Discussions:- Blocks, Assignment Help, Ask Question on Blocks, Get Answer, Expert's Help, Blocks Discussions

Write discussion on Blocks
Your posts are moderated

Write your message here..

Related Questions

Write an anonymous block that contains a pl/sql function, a. Write an anon... a. Write an anonymous block that contains a PL/SQL function. Given an order number orderNo, the function will calculate the total number of the parts in the order. Then the anonym

Create a procedure that update the status, Create a procedure named STATUS_... Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Unnest operator in sql, UNNEST operator in SQL The inverse operator of... UNNEST operator in SQL The inverse operator of GROUP is UNGROUP. SQL has an operator, UNNEST, that can be used for similar purposes, but its method of invocation is somewhat p

Parameter and keyword description - loop statements, Parameter and Keyword ... Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang

Relational operators-comparison operators, Relational Operators The rela... Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Tautology - equivalences rules, Tautology - Equivalences Rules: If the... Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta

Avoid the not null constraint - performance of application, Avoid the NOT N... Avoid the NOT NULL Constraint In the PL/SQL, using the NOT NULL constraint incur a performance cost. Consider the illustration as shown below: PROCEDURE calc_m IS m NUMB

Using forall and bulk collect - bulk bind performance, Using FORALL and BUL... Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

Oracle 9i features, Bitmap Join Indexes - This feature will increase th... Bitmap Join Indexes - This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization -This featur

Introduction to SQl and DQL, which operation is used if we are interested i... which operation is used if we are interested in only certain columns of a table?