Dec 202013
 
update sqlfail
set    next_post_date = date '2014-01-06';

I’m taking a bit of a break over Christmas while I spend time with my daughter and her grandparents. Thanks to everyone who follows this site, hope you have a great Christmas/festive time and 2014 is everything you hope for. :)

In the meantime, there’s a message hidden in the SQL below for you (note, you’ll need to run this on 11.2.0.2 to guarantee it works):

select listagg(keyword, ' ') 
         within group (
           order by decode(rn, 1, 8,
                               45, 2,
                               476, 5, 
                               766, 6, 
                               1638, 4, 
                               1654, 3, 
                               1683, 1,
                               1836, 7)) 
from (
  select keyword, 
         row_number() 
           over (order by keyword) rn
  from   v$reserved_words
)
where rn in (1,45,476,766,1638,1654,1683,1836);

  4 Responses to “Christmas Break”


  1. select
    listagg(vrw.keyword, ' ')
    within group(
    order by
    nullif(nvl(nullif(80-ascii(vrw.keyword), 3), 40), 47),
    tan(length(vrw.keyword)) desc
    )
    from v$reserved_words vrw
    where ora_hash(vrw.KEYWORD) in (2533331888, 3527693879, 2631970528, 1030426382, 895629286)

  2. Did you notice, that my query also works on 12.1 and, thus, is not restricted to some version ?

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)