Logical operators-pl/sql expressions , PL-SQL Programming

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.

 

1204_Logical Operators.jpg


                    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







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
Related Questions
Need to change mysql query to PDO Project Description: I want someone to convert me 1 .php file that includes some sql/mysql stuff to PDO is a very small file. Skills requ

Effects of NULL Operator As a general rule-but not a universal one-if NULL is an argument to an invocation of a system-defined read-only operator, then NULL is the result of t

Example of Using Aggregation on Nested Tables Example: How many students sat each exam WITH C_ER AS (SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM

Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

LEVEL You use the LEVEL with the SELECT CONNECT BY statement to categorize rows from a database table into a tree structure. The LEVEL returns the level number of a node in a

Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

Using Subqueries A subquery is a query (typically enclosed by parentheses) that appears within another SQL data manipulation statement. If evaluated, the subquery gives a va

Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

(a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c