Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Char String printing Order

Re: Char String printing Order

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 6 Jun 2005 07:26:40 -0700
Message-ID: <1118068000.444007.83800@g47g2000cwa.googlegroups.com>


An alternative to function creation.

SQL> SELECT SUBSTR('ORACLE',1,1) FROM DUAL   2 UNION ALL
  3 SELECT SUBSTR('ORACLE',2,1) FROM DUAL   4 UNION ALL
  5 SELECT SUBSTR('ORACLE',3,1) FROM DUAL   6 UNION ALL
  7 SELECT SUBSTR('ORACLE',4,1) FROM DUAL   8 UNION ALL
  9 SELECT SUBSTR('ORACLE',5,1) FROM DUAL  10 UNION ALL
 11 SELECT SUBSTR('ORACLE',6,1) FROM DUAL; S
-
O
R
A
C
L
E

Cheers. Received on Mon Jun 06 2005 - 09:26:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US