Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Santosh.
Asked: July 12, 2016 - 2:46 pm UTC
Last updated: July 12, 2016 - 3:01 pm UTC
Version: 11G
Viewed 1000+ times
THEN RT_UNE IS NULL
set null <null> create table t ( x int , y date, z int ); insert into t values (1, null, null); select case when y is null and z is null then x is null else x end c from t; Error at Command Line : 11 Column : 49 Error report - SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword" select case when y is null and z is null then null else x end c from t; C <null>
Santosh Lingampeta, July 12, 2016 - 3:09 pm UTC
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!