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

From: Alan <alan_at_erols.com>
Date: Wed, 24 Mar 2004 15:31:54 -0500
Message-ID: <c3sr6m$2b8mch$1@ID-114862.news.uni-berlin.de>

As I demonstrated in an earlier post, it existed in 7.3.4

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1079716693.83501_at_yasure...
> Terry Dykstra wrote:
>
> > 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
>
> Reverse goes back before 9i. Definitely in 8.1.7.4.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Wed Mar 24 2004 - 14:31:54 CST