Larry's boat

From: joel garry <joel-garry_at_home.com>
Date: Thu, 21 Feb 2013 15:09:52 -0800 (PST)
Message-ID: <66bba9dc-5c26-4166-b5b7-55d3007e9f65_at_vh9g2000pbb.googlegroups.com>



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
Received on Fri Feb 22 2013 - 00:09:52 CET

Original text of this message