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
THEORY OF BIOGENESIS - This theory explains that the existing living organisms originated from pre-existing living beings not from non living entities. This concept of or

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean's wants to create a trigger that automatically updates the stock level of all pr

EXIT-WHEN The EXIT-WHEN statement permits a loop to complete conditionally. Whenever the EXIT statement is encountered, the condition in the WHEN clause is computed. When the co

Create a Oracle procedure to produce vertical output format when selecting rows from a database table.


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

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou