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: SQL Serious Challenge # 1 - Probably Not Much Fun

Re: SQL Serious Challenge # 1 - Probably Not Much Fun

From: Alan <alan_at_erols.com>
Date: Thu, 18 Mar 2004 15:40:05 -0500
Message-ID: <c3d1ek$26gkrh$1@ID-114862.news.uni-berlin.de>


Connected to:
Oracle7 Server Release 7.3.4.0.0 - Production With the distributed, replication and parallel query options PL/SQL Release 2.3.4.0.0 - Production

SQL> SELECT REVERSE('FRED') FROM DUAL; REVE



DERF "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:c341ng$23u93p$1_at_ID-93924.news.uni-berlin.de...
> "Noons" <wizofoz2k_at_yahoo.com.au> schrieb im Newsbeitrag
> news:73e20c6c.0403150228.257d93a2_at_posting.google.com...
> > "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:<c32dkq$rki$1_at_titan.btinternet.com>...
> > > To reverse strings, 8.1 and above, - Yes, in there.
> > > if not 7.3.4 - I doubt it.
> > > select reverse('FRED') from dual;
> >
> > and STILL undocumented...
>

> Indeed ! Shocking ... I never stumbled upon REVERSE ( ) until I read this
> thread ...
> =8o|

>
> Received on Thu Mar 18 2004 - 14:40:05 CST

Original text of this message

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