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
Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT.  A screen dump of the output is acceptable. Show as many rows as you can. A screen dump i

Question 1. Update stock levels when the order is cancelled At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a

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

Assigning and Comparing Collections One collection can be assigned to other by an SELECT, INSERT, UPDATE, or FETCH statement, an assignment statement, or by a subprogram call. A

Transaction Control The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manip

Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

Authorisations - Privileges As relational theory is silent on the issue of authorisation, it offers nothing with which SQL's vast edifice in support of what it calls privilege

LONG and LONG RAW You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length o

Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic

Forward Declarations The PL/SQL needs that you declare an identifier before using it. And hence, you should declare a subprogram before calling it. For illustration, the decla