Comparison operators- pl/sql, PL-SQL Programming

Comparison Operators

The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in conditional control statements and in the WHERE clause of the SQL data manipulation statements. Now there are a couple of examples as shown below:

IF quantity_on_hand > 0 THEN
UPDATE inventory SET quantity = quantity - 1
WHERE part_number = item_number;
ELSE
...
END IF;

Posted Date: 10/3/2012 5:19:50 AM | Location : United States







Related Discussions:- Comparison operators- pl/sql, Assignment Help, Ask Question on Comparison operators- pl/sql, Get Answer, Expert's Help, Comparison operators- pl/sql Discussions

Write discussion on Comparison operators- pl/sql
Your posts are moderated
Related Questions
Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

Using Operator VALUE: As you may expect, the operator VALUE returns the value of an object. The VALUE takes its argument a correlation variable.  For illustration, to return a

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

Disjunction (OR, ∨) Again we have nine rows instead of just four and again, when unknown is not involved, the rows are as for 2VL. Also, when anything is paired with true, t

Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Bulk Fetching The illustration below shows that you can bulk-fetch from a cursor into one or more collections: DECLARE TYPE NameTab IS TABLE OF emp.ename%TYPE; TYPE S

Semijoin and Composition - SQL For semijoin, the dyadic relational operator MATCHING, defined thus: r1 MATCHING r2, where r1 and r2 are relations such that r1 JOIN r2 is de

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

Collections:   The collection is an ordered group of elements, all of similar type (for illustration, the grades for a class of students). Each element has an exclusive subsc