Sequential control - pl/sql, PL-SQL Programming

Sequential Control

Dissimilar to the IF and LOOP statements, the GOTO and NULL statements are not important to the PL/SQL programming. The configuration of PL/SQL is such that the GOTO statement is seldom required. Seldom, it can simplify the logic enough to warrant its use. The NULL statement can improve the readability by making the meaning and action of the conditional statements clear.

The Overuse of the GOTO statements can result in complex, unstructured code (art many times
Known as the spaghetti code) which is hard to understand and maintain. Thus, use the GOTO statements sparingly. For instance, to branch from a deeply nested structure to an error-handling routine, raise an exception instead of using a GOTO statement.

Posted Date: 10/3/2012 6:01:17 AM | Location : United States







Related Discussions:- Sequential control - pl/sql, Assignment Help, Ask Question on Sequential control - pl/sql, Get Answer, Expert's Help, Sequential control - pl/sql Discussions

Write discussion on Sequential control - pl/sql
Your posts are moderated
Related Questions
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

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

Using Aliases The Select-list items fetched from a cursor related with the %ROWTYPE should have simple names or, if they are expressions, should have aliases. In the example bel

Package STANDARD The package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available

Keyword &Parameter Description: index_name: This is an undeclared identifier which can be referenced only within the FORALL statement and only as the collection subscript

Extension and AND in SQL The theory book gives the following simple example of relational extension in Tutorial D: EXTEND IS_CALLED ADD ( FirstLetter ( Name ) AS Initial )

Data Abstraction The Data abstraction extracts the important properties of data while ignoring the not necessary details. Once you design a data structure, you can fail to reme

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

Parameter and Keyword Description: record_type_name: This identifies the user-defined type specifier that is used in the subsequent declarations of the records. NOT N

Procedures   The procedure is a subprogram which performs a specific action. You write procedures using the syntax as shown below: PROCEDURE name [(parameter[, parameter, .