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
Map and Order Methods: The values of the scalar datatype like CHAR or REAL have a predefined order that allows them to be compared. While, the instances of an object type has

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

Procedures The procedure is a subprogram which can take parameters and be invoked. Normally, you can use a procedure to perform an action. The procedure has 2 sections: the spe

Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment

Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

Using the student and faculty tables create a select query that outputs all students for a specific advisor. Generate the execution plan, select out the explain plan . Create an

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illu

Use of COUNT in SQL It describes and discusses various general methods of expressing constraints, eventually noting that support for "=" with relation operands is sufficient f

Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP