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
Varrays versus Nested Tables The Nested tables are differing from varrays in the following ways: 1)  Varrays have a maximum size, while nested tables do not. 2)  Varrays are

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Effects of NULL Operator As a general rule-but not a universal one-if NULL is an argument to an invocation of a system-defined read-only operator, then NULL is the result of t

Write a program to implement the inverted file shown in the slides (Simple Index file, LabelID file and Data file).  Use the Avail_List to point at the deleted Label IDs so that th

Special cases of projection This section describes the identity projection, r {ALL BUT}, and the projection on no attributes, r { }, which yields TABLE_DUM when r is empty, ot

MILLER-UREY' S EXPERIMENTAL PROCEDURES - They recreated the probable conditions on the primitive earth in the laboratory. An atmosphere containing hydrogen, ammonia, me

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

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

Restriction in SQL Syntax: SELECT DISTINCT StudentId FROM IS_CALLED WHERE Name = 'Boris' The WHERE clause operates on the result of the FROM clause in analogo

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