The most successful SQL Oracle statement

If you write that SQL statement of the most accomplished, what would you write?
The content is not limited, with the Oracle, this topic is broad, set no concrete conditions
The written examination question, we do not know what to write

Started by Spark at February 04, 2016 - 2:33 AM

select * from dual

Posted by Steven at February 08, 2016 - 3:33 AM

with t as (..)

Posted by Mike at February 23, 2016 - 3:55 AM

merge into

Posted by Darren at February 26, 2016 - 4:38 AM

+1

Posted by Daphne at March 01, 2016 - 4:40 AM

Write more found, how come no achievement.

Posted by Adalheid at March 06, 2016 - 5:24 AM

The stored procedure.

Posted by Caesar at March 19, 2016 - 6:05 AM

+1

Posted by Kerwin at November 26, 2016 - 8:50 PM

Creative enough to taste

Posted by Avivahc at December 04, 2016 - 9:34 PM

After many fields in the string will be a symbol of how would you remove is several times the interception or...

General trim is used to remove the space but it rarely see people use is also used in few opportunities

with t1 as
(
     select '12,34,56,' c1 from dual union all
     select ',a,b,' c1 from dual union all
     select '11,22,33' c1 from dual union all
     select ',aa,bb,cc' c1 from dual
)

select trim(',' from c1) c1
from t1

       c1
---------------------
1	12,34,56
2	a,b
3	11,22,33
4	aa,bb,cc

Posted by Avivahc at December 11, 2016 - 10:08 PM

select sysdate from dual, 

Posted by Corey at December 14, 2016 - 10:54 PM

select tname from tab;

Posted by Byron at December 18, 2016 - 11:44 PM

To do a day, and then roll back

Posted by Nathan at December 31, 2016 - 12:04 AM

I do not know why Oracle instead of a dual

Posted by Bernard at January 02, 2017 - 2:04 AM

select 1 from dual; This dual.

Posted by Tommy at January 07, 2017 - 12:34 AM

select women from people
where appearance='cute'

Posted by Rupert at January 10, 2017 - 1:06 AM