Boolean values-assignments in pl/sql, PL-SQL Programming

Boolean Values

Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration

DECLARE
done BOOLEAN;
the following statements are legal:
BEGIN
done := FALSE;
WHILE NOT done LOOP
...
END LOOP;


Whenever applied to an expression, the relational operators return  Boolean value. Therefore, the assignment below is legal:

done := (count > 500);

Posted Date: 10/3/2012 5:07:13 AM | Location : United States







Related Discussions:- Boolean values-assignments in pl/sql, Assignment Help, Ask Question on Boolean values-assignments in pl/sql, Get Answer, Expert's Help, Boolean values-assignments in pl/sql Discussions

Write discussion on Boolean values-assignments in pl/sql
Your posts are moderated
Related Questions
Synonyms You can create the synonyms to provide location transparency for the remote schema objects like tables, views, sequences, stand-alone subprograms, and packages. Though,

heap sort program in pl/sql

Effects of NULL in Aggregate Operator - SQL Let aggop(x) be an invocation of some aggregate operator aggop in SQL, where x is an expression (usually an open expression) to be

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

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

Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Due to an increase in overhead costs, the buying price of all items needs to be increased. Management wants to see a report before deciding how much each product will go up. Add to

Overloading: Similar to packaged subprograms, methods of the same type can be overloaded. That is, you can use similar name for various methods if their formal parameters diff

Processing Transactions This part describes how to do the transaction processing. You learn the fundamental techniques that safeguard the consistency of your database, involvin

Positional Notation The first procedure call uses the positional notation. The PL/SQL compiler relates the first actual parameter, account, with the first proper parameter, ac