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
SQL outer join SELECT * FROM IS_CALLED NATURAL LEFT JOIN IS_ENROLLED_ON Note that adding LEFT to an invocation of CROSS JOIN has no effect unless the right-hand operand

Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v

Benefit of the dynamic SQL: This part shows you how to take full benefit of the dynamic SQL and how to keep away from some of the common pitfalls. Passing the Names of Sc

what is the use of declare keyword

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

Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

Type versus Representation Confusion in SQL This describes how a value might have two or more distinct representations. For example, user-defined type POINT might have a decla

Project Description: This is stage 1 of a larger conversion project. We are converting a traditional Server/Client application written in Access 2007 into a web interface with S

Naming Conventions The similar naming conventions apply to all PL/SQL program items and units including the variables, cursors, constants, cursor variables, procedures, exception

Using the FORALL Statement The keyword FORALL instruct the PL/SQL engine to bulk-bind input collections before sending them all to the SQL engine. Though the FORALL statement