Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Char String printing Order
Michel Cadot wrote:
> "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
It appears the simplest solution is the best solution.
David Fitzjarrell Received on Mon Jun 06 2005 - 11:12:29 CDT