What is the data type of NULL ?
gerardnico@orcl>create VIEW nullview 2 AS 3 SELECT NULL "null" FROM dual; VIEW created. gerardnico@orcl>describe nullview; Name NULL? Type -------------- ------------------------------------- NULL VARCHAR2
gerardnico@orcl>create VIEW nullview 2 AS 3 SELECT NULL "null" FROM dual; VIEW created. gerardnico@orcl>describe nullview; Name NULL? Type -------------- ------------------------------------- NULL VARCHAR2