Overview of control structures-comparison operators, PL-SQL Programming

Overview of control structures

According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can be combined in any way but is necessary to deal with the given problem.

 

 

2283_Overview of control structures-comparison operators.jpg

 

                                                       Figure: Control Structures


The selection structure tests the condition, and then executes one sequence of statements as an alternative of another, depending on whether the condition is true or false. The condition is any variable or expression that returns a Boolean value (TRUE or FALSE). The iteration structure executes a series of statements repetitively as long as a condition holds true. The sequence of structure simply executes a sequence of the statements in the order in which they occur.

Posted Date: 10/3/2012 5:39:50 AM | Location : United States







Related Discussions:- Overview of control structures-comparison operators, Assignment Help, Ask Question on Overview of control structures-comparison operators, Get Answer, Expert's Help, Overview of control structures-comparison operators Discussions

Write discussion on Overview of control structures-comparison operators
Your posts are moderated
Related Questions
Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database. This view should return these columns from the

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

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

Predicate - SQL Consider the declarative sentence-a proposition-that is used to introduce this topic:  "Student S1, named Anne, is enrolled on course C1." Recall that th

Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which

i NEED THE QURIES TO SOME OF THE PROBLEMS USING plsql

Closing a Cursor The CLOSE statements disable the cursor, and the result set becomes undefined. An illustration of the CLOSE statement as shown: CLOSE c1;

DELETE Statement The DELETE statement eliminates whole rows of data from the specified table or view. Syntax:

Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Using Operator VALUE: As you may expect, the operator VALUE returns the value of an object. The VALUE takes its argument a correlation variable.  For illustration, to return a