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: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 6 Jun 2005 17:46:35 +0200
Message-ID: <42a46f78$0$14614$636a15ce@news.free.fr>

"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

Original text of this message

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