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
OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

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

%NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts

PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -

DBMS: The answer to this question is of course given in of the theory book. This book is concerned with SQL DBMSs and SQL databases in particular. Soon we will be looking a

Create a procedure named STATUS_SHIP_SP that allows a company to employee in the Shipping Department to update the status of an order to add shipping information. The BB_BASKETSTAT

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

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