Re: Larry's boat

From: joel garry <joel-garry_at_home.com>
Date: Fri, 22 Feb 2013 09:10:00 -0800 (PST)
Message-ID: <5694f1a4-a4d5-479b-a322-e7b389b0d97d_at_kk9g2000pbc.googlegroups.com>

On Feb 21, 6:34 pm, John Hurley <johnthehur..._at_gmail.com> wrote:
> On Feb 21, 6:09 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
>
>
>
>
>
>
> > set pages 0
> > SELECT rpad(' ',length)||keyword
> > FROM   ( SELECT length
> >               , keyword
> >               , ROW_NUMBER() OVER (PARTITION BY length ORDER BY
> > keyword) -1 AS seq
> >          FROM   v$reserved_words)
> > WHERE  connect_by_isleaf = 1
> > CONNECT BY seq = PRIOR seq +1 AND length = PRIOR length
> > START WITH seq = 1
> > /
>
> > jg
> > --
> > _at_home.com is bogus.
> > Pirates do pARRRRtitioning
>
> I am ( as usual ) really really confused.
>
> Could you perhaps give a hint or two about what this is supposed to
> mean and/or why you posted it?

Actually what happened was I was building a complicated report for work in my head, and poking around on the forums looking at a "how do I make this delete go faster?" question. So I pointed the person at a William Robertson analytics example on orafaq, and started pondering explain plans where Oracle decides to make a view which includes two FTS of a large table. So I started poking around the intertubes and found a Mark Rittman example of an analytic query on emp and dept, which made a triangle. So I went, "hmmm, I wonder if I could make an XMAS tree ascii art out of an analytics query small enough to tweet?" Then I kinda accidentally did this thing and went, oh, a sail. Maybe someone will think that's cool and take the idea of coding easter egg ascii art in analytics further.

Meanwhile I have to get all this work code out of my head through my fingers before I forget it or yet another Important Request comes in.

jg

--
_at_home.com is bogus.
HP was the best performer in the S&P 500 yesterday.  Wow, that
Invisible Hand thing, must be doing invisible Face Palms.

Received on Fri Feb 22 2013 - 18:10:00 CET