Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Char String printing Order
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