Comparison operators - sql operators, PL-SQL Programming

Comparison Operators

Usually, you use the comparison operators in the WHERE clause of a data manipulation statement to form the predicates, that compare one expression to another and always yields the TRUE, FALSE, or NULL. You can use all the comparison operators listed below to form the predicates. Furthermore, you can merge predicates using the logical operators AND, OR, & NOT.

1668_comparison operators.png

1630_comparison operators1.png

Posted Date: 10/4/2012 3:46:40 AM | Location : United States







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

Write discussion on Comparison operators - sql operators
Your posts are moderated
Related Questions
LOOP Statements The LOOP statements execute a series of statements at multiple times. The loops enclose the series of statements that is to be repeated. The PL/SQL provides typ


What Are Cursor Variables  ? The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, decl

Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope

Number Types The Number types permit you to store the numeric data (real numbers, integers, and floating-point numbers), show quantities, and do computations. BINARY_INTEG

COSMOZOI C THEORY - Richter (1865) proposed the cosmozoic theory that says that life came by spores (cosmozoa) or other particles from other planets on the earth.

Using COMMIT The COMMIT statements end the present transaction and make permanent any changes made during that transaction. Till you commit the changes, other users cannot acc

Using EXISTS The EXISTS(n) returns TRUE if the nth element in a collection exist. Or else, EXISTS(n) returns FALSE. Primarily, you use EXISTS with DELETE to maintain the spars

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Conditionals - SQL At first sight SQL does not appear to have a single operator for expressing logical implication. In this respect it would be in common with most programming