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

Manipulating objects in pl sql, Manipulating Objects: You can use an o... Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

Oracle 11 g new features , Oracle 11 G new features associated with this re... Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

I want database development with analysis tools, Project Description: I ... Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab

Using the collection methods, Using the Collection Methods The collecti... Using the Collection Methods The collection methods below help to generalize the code and make collections easier to use and also make your applications easier to maintain:

Advantages of subprograms, Advantages of Subprograms The Subprograms g... Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which

Between and not between operator in sql, BETWEEN and NOT BETWEEN Operator i... BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM

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

Update the Status of an Ordere, Create a procedure named STATUS_SHIP_SP tha... 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

Translate the given er schema into sql, Consider the schema for FreeCheckin... Consider the schema for FreeChecking Bank, that we designed given below. Translate the given ER schema into SQL CREATE TABLE statements (indicating primary key, unique and foreign

Opening a cursor, Opening a Cursor Opening the cursor executes the que... Opening a Cursor Opening the cursor executes the query & identifies the result set that consists of all rows that meet the query search criteria. For the cursors declared usin