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
Task 2 [12 marks] Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place

Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv

Using SET TRANSACTION You use the SET TRANSACTION statement to begin the read-only or read-write transaction, start an isolation level, or assign your present transaction to a

Keyword and Parameter Description: table_reference: This specifies a table or view that should be accessible when you execute the DELETE statement, and for that you must

Many of the reports generated from the system calculate the total dollars in purchases for a shopper. Complete the following steps to create a function named TOT_PURCH_SF that acce

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

heap sort program in pl/sql

CURRVAL and NEXTVAL The series is a schema object which generates the sequential numbers. Whenever you form a sequence, you can specify its primary value and an increment. T

which operation is used if we are interested in only certain columns of a table?

to write a heap sort program usin pl-sql