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
Character Types The Character types allow you to store alphanumeric data, represent words and text, and manipulate the character strings. CHAR You use the CHAR dataty

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

Usefulness of Data Type In SQL, as in most computer languages, a type can be used for constraining the values that are permitted to be used for some purpose. In particular, i

Create the four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the

Creating and Destroying Base Tables: Example shows an SQL command to create the base table counterpart of the ENROLMENT variable Example  Creating a base table. CREATE T

We are seeking a freelance consultant that is familiar with Appgen applications. We require exporting all our data into a format appropriate for importing into SAP Business One. Pl

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

%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Using the Collection Methods The collection methods below help to generalize the code and make collections easier to use and also make your applications easier to maintain:

Parameter and Keyword Description: type_name: This identifies a user-defined type specifier that is used in the subsequent declarations of the objects. AUTHID Clause: