Begin parameter description in pl sql, PL-SQL Programming

BEGIN Parameter Description in pl sql:

BEGIN:

This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The executable section of a block is needed. That is, the PL/SQL block should contain at least one executable statement. The NULL statement meets this necessity.

Statement:

This is an executable (that is not declarative) statement which you use to create the algorithms. A series of statements can involve the procedural statements like RAISE, SQL statements like the UPDATE, and PL/SQL blocks (sometimes known as the "block statements").

The PL/SQL statements are free format. That is, they can continue from line to line if you do not crack keywords, delimiters, or literals across the lines. A semicolon (;) serve as the statement terminator.

The PL/SQL supports a subset of the SQL statements which involves the cursor control, data manipulation, and transaction control statements but exclude the data definition and data control statements like CREATE, ALTER, GRANT, and REVOKE.

EXCEPTION:

This keyword signals the beginning of the exception-handling section of the PL/SQL block. When an exception is raised, the normal execution of the block stops and control transfers to the suitable exception handler. After the exception handler complete, the execution proceeds with the statement following the block.

If there is no exception handler for the raised exception in the present block, the control passes to the enclosing block. This process repeat until an exception handler is found or there are no more enclosing blocks. If the PL/SQL can find no exception handler for the exception, the execution stops and an unhandled exception error is returned to the host atmosphere.

exception_handler:

This construct relates an exception with a series of statements that is executed when the exception is raised.

END:

This keyword signals the end of the PL/SQL block. It should be the last keyword in a block. Neither the END IF in an IF statement nor the END LOOP in a LOOP statement can replace for the keyword END. The END does not signal the end of a transaction. Merely as a block can span the multiple transactions, a transaction can span the multiple blocks.

Posted Date: 10/6/2012 8:56:33 AM | Location : United States







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

Write discussion on Begin parameter description in pl sql
Your posts are moderated
Related Questions
Project Description: We organize an online system called ACPAS we have created a project called EVO that can be use by our customers to integrate their web sites with the Acpas

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:

How Transactions Guard Your Database The transaction is a sequence of SQL data manipulation statements which does a logical unit of work. The Oracle treats the sequence of SQL

Block Structure The PL/SQL is a block-structured language. That is, the fundamental units (procedures, anonymous blocks, and functions) that make up a PL/SQL program are logi

LIKE Operator You use the LIKE operator to compare the character value to a pattern. The Case is significant. LIKE returns the Boolean value TRUE when the character patterns mat

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

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

Type versus Representation Confusion in SQL This describes how a value might have two or more distinct representations. For example, user-defined type POINT might have a decla

EXIT Statement   You can use the EXIT statement to exit a loop. The EXIT statement has 2 forms: the conditional EXIT WHEN and the unconditional EXIT. With the either form, you

Set Operators The Set operators combine the results of the two queries into one result. The INTERSECT returns all the distinct rows selected by both queries. The MINUS returns