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
Package Body: The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the pac

EXECUTE Privilege To call an invoker-rights routine straightforwardly, the users should have the EXECUTE privilege on that routine. By yielding the privilege, you permit a user

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.parent_fname), b.parent_lname,b.parent_tphone FROM child a,parent b WHERE a.parent_id=b.parent_id ORDER BY a.child_fnam

Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no

Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang

Semijoin and Composition - SQL For semijoin, the dyadic relational operator MATCHING, defined thus: r1 MATCHING r2, where r1 and r2 are relations such that r1 JOIN r2 is de

Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

I need SQL Data Base Project Description: Network SQL database and SQL Setup two 4 workstation Skills required are Data Entry, MySQL, SQL

Subprograms The PL/SQL has two types of subprograms known as the procedures and functions that can take parameters and be invoked. As the following example represents, a subp