Begin parameter description in pl sql, PL-SQL Programming

Assignment Help:

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.


Related Discussions:- Begin parameter description in pl sql

Parameter default values, Parameter Default Values As the illustration ...

Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

Exit statement - syntax, EXIT Statement   You can use the EXIT stateme...

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

Third step at defining type sid in sql, Third Step at defining type SID in ...

Third Step at defining type SID in SQL CREATE DOMAIN SID AS VARCHAR(5) CHECK ( VALUE IS NOT NULL AND SUBSTRING(VALUE FROM 1 FOR 1) = 'S' AND CAST('+'||SUBSTRING(VALUE

Remote operations in pl sql, Remote Operations: As the illustration sh...

Remote Operations: As the illustration shows below, the PL/SQL subprograms can execute the dynamic SQL statements which refer to the objects on a remote database: PROCEDURE

Closest approximation to relational union - sql, Closest Approximation to R...

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

Boolean values-assignments in pl/sql, Boolean Values Only the values TRU...

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

Package dbms output in pl/sql, DBMS_OUTPUT: The Package DBMS_OUTPUT en...

DBMS_OUTPUT: The Package DBMS_OUTPUT enables you to display output from the PL/SQL subprograms and blocks, that makes it easier to test and debug them. The procedure put_ line

In operator-comparison operators, IN Operator The operator IN tests the ...

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Relational algebra - sql, Relational Algebra - SQL It describes some ...

Relational Algebra - SQL It describes some operators, that together constitute an algebra that is not only relationally complete but also irreducibly so (very nearly- apart f

Example of foreign key constraint - sql, Example of Foreign Key Constraint ...

Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd