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
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

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

Entering and Exiting If you enter the executable part of an autonomous routine, the major transaction suspends. When you exit the routine, the major transaction resumes. To ex

Data Types in SQL - Timestamp TIMESTAMP for values representing points in time on a specified uniform scale. DATE is used for timestamps on a scale of one day, such as DATE '2

Using Invoker Rights: By default, the stored procedure executes with the privileges of its definer, not its invoker. These procedures are bound to the schema in which they inh

Functions   The function is a subprogram that calculates a value. The Functions and procedures are structured similar, except that the functions have a RETURN clause. You can

Procedures   The procedure is a subprogram which performs a specific action. You write procedures using the syntax as shown below: PROCEDURE name [(parameter[, parameter, .

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

Use External Routines The PL/SQL is particular for the SQL transaction processing. Therefore, several tasks are more quickly completed in a lower-level language like C that is

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut