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
Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

Example of NOT EXISTS in SQL Example: Use of NOT EXISTS CREATE ASSERTION Must_be_enrolled_to_take_exam_alternative1 CHECK ( NOT EXISTS (SELECT StudentId, CourseId

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen

Name Resolution   During the compilation, the PL/SQL compiler relates identifiers like the name of a variable with an address or memory location, actual value, or datatype. Th

Order of Evaluation When you do not use the parentheses to specify the order of evaluation, the operator precedence determine the order. Now compare the expressions below: NOT

I need a query for PL/SQL, selecting names with cursor, goes down the list, assigns usernames (initials001) based on initials in the name. If two names have same initials the user

Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th

Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv

On occasion, some of Brewbean's customers mistakenly leave an item out of a basket already checked out, so they create a new basket containing the missing items. However, they requ