Re: Larry's boat

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 21 Feb 2013 23:14:06 +0000 (UTC)
Message-ID: <pan.2013.02.21.23.14.05_at_gmail.com>

On Thu, 21 Feb 2013 15:09:52 -0800, joel garry 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

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
 10 /

 }
  TX
   YES
    ZONE

     XMLPI
      WITHIN
       XMLTYPE
	XMLTABLE
	 XMLSCHEMA
	  XPATHTABLE
	   X_DYN_PRUNE
	    XMLTRANSFORM
	     XMLNAMESPACES
	      XS_SYS_CONTEXT
	       VERSIONS_ENDSCN
		XML_DML_RWT_STMT
		 VERSIONS_STARTSCN
		  VERSIONS_STARTTIME
		   XDB_FASTPATH_INSERT
		    XMLINDEX_SEL_IDX_TBL
		     USE_INVISIBLE_INDEXES
		      TRANSFORM_DISTINCT_AGG
		       SYS_XMLNODEID_GETPATHID
			SYS_XMLNODEID_GETLOCATOR
			 USE_HASH_GBY_FOR_PUSHDOWN
			  XMLINDEX_REWRITE_IN_SELECT
			   NO_FULL_OUTER_JOIN_TO_OUTER
			    POWERMULTISET_BY_CARDINALITY

29 rows selected.

Elapsed: 00:00:00.21
SQL>

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com

Received on Fri Feb 22 2013 - 00:14:06 CET