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
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

Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

Updating by insertion Syntax : INSERT INTO ENROLMENT VALUES (SID ('S4'), 'Devinder', CID ('C1'));

Lightweight system to provide and take info from workers in the field and office, have basic design outlined already just require build and implementation Desired Skills CSS,

This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

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

Quantification in SQL To quantify something, as the theory book has it, is to state its quantity, to say how many of it there are. For example, in Tutorial D the expression CO

Hi,am developing a library system and relating all the table is somehow complex,could you kindly assist me

Difference between 9i & 10G When Oracle releases any new databases then it are having some discrepancy with them. But 10G is having much difference than oracle 9i has. Oracle

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t