Logical Operators


The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

 

                    Table: Logic Truth Table

As the truth table shown below, the AND returns TRUE only if both its operands are true. On the other hand, the OR returns TRUE if either of its operands is true. The NOT returns the opposite value (logical negation) of its operand. For illustration, NOT TRUE returns FALSE.

The NOT NULL returns NULL as nulls are indeterminate. It follows that if you apply the NOT operator to a null, the answer is also indeterminate.

Posted Date: 10/3/2012 5:15:37 AM | Location : United States

Ask an Expert

Related Discussions:- Logical operators-pl/sql expressions , Assignment Help, Ask Question on Logical operators-pl/sql expressions , Get Answer, Expert's Help, Logical operators-pl/sql expressions Discussions

Write discussion on Logical operators-pl/sql expressions
Your posts are moderated

Write your message here..

Related Questions

Effect of anonymous columns, Effect of Anonymous Columns Now, recall t... Effect of Anonymous Columns Now, recall that a VALUES expression denotes a table with undefined column names. If an initial value is to be specified when a base table is creat

Semidifference via except and join - sql, Semidifference via EXCEPT and JOI... Semidifference via EXCEPT and JOIN - SQL SELECT * FROM (SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' EXCEPT DISTINCT CORRESPONDING SELECT StudentId

Aggregate assignment-declarations in sql, Aggregate Assignment The %ROWT... Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Cursor variables, Cursor Variables Similar to a cursor, cursor variable... Cursor Variables Similar to a cursor, cursor variable points to the current row in the result set of a multi-row query. But, dissimilar a cursor, a cursor variable can be opene

Use the returning clause -improve performance of application, Use the RETUR... Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

Package standard, Package STANDARD The package named STANDARD defines t... Package STANDARD The package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available

Keyword & parameter description - exceptions, Keyword & Parameter Descripti... Keyword & Parameter Description: WHEN: This keyword introduces the exception handler. You can have many exceptions execute the similar sequence of the statements by follo

Definition of from - sql, Definition of FROM - SQL Recall that the ope... 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

Using aggregation on nested tables - sql, Using Aggregation on Nested Table... Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no

Declaring and initializing objects in pl/sql, Declaring and Initializing Ob... Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa