{{theTime}}

Search This Blog

Total Pageviews

NULLS in PL/SQL:

NULLS in PL/SQL:

 - Represents unknown or inapplicable values
 - Never equal or not equal to anything
 - Most functions other than NVL, NVL2, CONCAT, REPLACE will return NULL when passed a Null
 - Use IS null OR IS NOT NULL to check NULL values

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...