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

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca.x>
Date: Fri, 19 Mar 2004 17:08:34 GMT
Message-ID: <mOF6c.218186$A12.207036@edtnps84>

Does it work in PL/SQL in 9i or 10g? I tried in 8174 and it failed:

  1 declare
  2 ls_result varchar2(10);
  3 begin
  4 select reverse('oracle') into ls_result from dual;   5* end;
SQL> /
select reverse('oracle') into ls_result from dual;

       *
ERROR at line 4:

ORA-06550: line 4, column 8:
PLS-00201: identifier 'REVERSE' must be declared
ORA-06550: line 4, column 1:

PL/SQL: SQL Statement ignored

-- 
Terry Dykstra
Canadian Forest Oil Ltd.
"Alan" <alan_at_erols.com> wrote in message
news:c3d1ek$26gkrh$1_at_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 Fri Mar 19 2004 - 11:08:34 CST