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
SQL Is a Database Language: The commands given to a DBMS by an application are written in the database language of the DBMS. The term data sublanguage is sometimes used instea

UNION and OR - SQL SQL supports UNION explicitly but differently from the way it supports JOIN explicitly. As we have seen, JOIN is used exclusively within the FROM clause, su

The 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 p

DELETE Command - SQL Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows

Example of WHEN or THEN Constraints A concrete example showing how SQL supports WHEN/THEN constraints CREATE TABLE SAL_HISTORY (EmpNo CHAR (6), Salary INTEGER NOT NULL,

Keyword & Parameter Description: WHEN: This keyword introduces the exception handler. You can have many exceptions execute the similar sequence of the statements by follo

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

Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

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

Question: a) Given the following relation: Location(loc_id, bldg_code, room, capacity) The underlined field is a primary key. (i) Write a PL/SQL program using the impl