Is null operator-comparison operators, PL-SQL Programming

IS NULL Operator

The IS NULL operator returns the Boolean value TRUE whenever its operand is null or FALSE if it is not null. The comparisons including the nulls always yield NULL. And hence, to test for nullity (the state of being null), then do not use the statement

IF variable = NULL THEN...




Rather, use the statement below:

IF variable IS NULL THEN...

Posted Date: 10/3/2012 5:23:05 AM | Location : United States







Related Discussions:- Is null operator-comparison operators, Assignment Help, Ask Question on Is null operator-comparison operators, Get Answer, Expert's Help, Is null operator-comparison operators Discussions

Write discussion on Is null operator-comparison operators
Your posts are moderated
Related Questions
Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b

Relational Algebra - SQL It describes some operators, that together constitute an algebra that is not only relationally complete but also irreducibly so (very nearly- apart f

Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_

ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

to write a heap sort program usin pl-sql

Deriving Predicates from Predicates in SQL The corresponding section in the theory book describes how predicates can be derived from predicates using (a) the logical connectiv

NULL Statement The NULL statement clearly specifies in action; it does nothing other than to pass control to the next statement. It can, though, improve the readability. In a

Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

Named Notation The second procedure call uses the named notation. An arrow (=>) serve as the relationship operator that associates the formal parameter to the left of the arro