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
Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

Cursors   To execute the multi-row query, the Oracle opens an unnamed work region which stores the processing information. The cursor names the work region, access the informa

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

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

heap sort program in pl/sql

Defining REF CURSOR Types To make cursor variables, you take 2 steps. At first, you define a REF CURSOR type, and then declare the cursor variables of that type. You can defin