Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Char String printing Order
"Jignesh" <jigneshocp_at_gmail.com> a écrit dans le message de
news:1118060289.272545.248560_at_o13g2000cwo.googlegroups.com...
| Dear All,
| I faced a question in interview that if you have a string. e.g.
| "ORACLE" and want to print it as following using SQL stat.
| O
| R
| A
| C
| L
| E
|
| How can you do it ?
|
| Will anybody help ?
|
|
| Jignesh
|
Try:
col o format a1
select 'ORACLE' o from dual;
Regards
Michel Cadot
Received on Mon Jun 06 2005 - 10:46:35 CDT