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, krishna.
Asked: February 16, 2018 - 3:52 pm UTC
Last updated: February 19, 2018 - 9:43 am UTC
Version: 11
Viewed 1000+ times
SQL> create table t ( a int, b int, c int, d int ); Table created. SQL> SQL> insert into t values (1,2,3,4); 1 row created. SQL> SQL> select 2 a, 3 b, 4 c, 5 a+b-c+d/2+10-sqrt(c) as ugh 6 from t; A B C UGH ---------- ---------- ---------- ---------- 1 2 3 10.2679492 1 row selected. SQL> SQL> select 2 a, 3 b, 4 c, 5 ugh, 6 case when ugh > 0 then 'Y' else 'N' end more_stuff 7 from 8 ( 9 select 10 a, 11 b, 12 c, 13 a+b-c+d/2+10-sqrt(c) as ugh 14 from t 15 ); A B C UGH M ---------- ---------- ---------- ---------- - 1 2 3 10.2679492 Y 1 row selected.
The Oracle documentation contains a complete SQL reference.