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

Merge two data sources to sql azure database, Project Description: I hav...

Project Description: I have two types of data sources. One that is a list in SharePoint and another that is an access desktop database. The access desktop database is fairly com

Using count, Using COUNT The COUNT returns the number of elements that...

Using COUNT The COUNT returns the number of elements that a collection presently contains. For instance, when a varray projects contains 15 elements, then the following IF con

%rowtype - cursors, %ROWTYPE: This attribute gives a record type which ...

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

While-loop - iterative control, WHILE-LOOP The WHILE-LOOP statement rela...

WHILE-LOOP The WHILE-LOOP statement relates a condition with the series of statements enclosed by the keywords LOOP and END LOOP, as shown: WHILE condition LOOP sequence_of_sta

Creating a sql file, Creating a SQL file 1. Open a new file in Notepad...

Creating a SQL file 1. Open a new file in Notepad++ and save it to the location c:\mysql\bin, with the name lab8script.sql (the file extension should be .sql ). Add a MySQL co

Effects of null for multiple assignments - sql, Effects of NULL for Multipl...

Effects of NULL for Multiple Assignments - SQL If the row expression given as the source for a multiple assignment evaluates to NULL, then NULL is assigned to each target. If

Keyword & parameter description - expressions, Keyword & Parameter Descript...

Keyword & Parameter Description: boolean_expression: This is an expression which yields the Boolean value that is TRUE, FALSE, & NULL. character_expression: This

Null statement-sequential control, NULL Statement The NULL statement c...

NULL Statement The NULL statement clearly specifies in action; it does nothing other than to pass control to the next statement. It can, though, improve the readability. In a

Role of abstraction in pl/sql, Role of Abstraction in pl/sql: The abst...

Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

Adding table constraints, Adding Table Constraints ALTER TABLE ENROL...

Adding Table Constraints ALTER TABLE ENROLMENT ADD CONSTRAINT NameNotNull CHECK (Name IS NOT NULL) ; ALTER TABLE ENROLMENT ADD CONSTRAINT PK_StudentId_CourseId PRIM

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