My apologies for the RTFM. I guess it
isn't documented, even though it has been
around for several years.
Jared
On Tue, 13 Mar 2001, Jack C. Applewhite wrote:
> Jared,
>
> Well, I've RTFM for 8.1.6 and the SQL Reference doesn't
> mention a Reverse() function. However, there is a supplied
>
Title: RE: AW: Script for reversing a string?
Jack,
According to
the article, Oracle has not documented it
anywhere.
R. Matt
Adams - GE Appliances - [EMAIL PROTECTED] Contrary to popular opinion, Unix is user
friendly. It's just
particular about who it makes fr
Title: RE: AW: Script for reversing a string?
Matt,
I'm glad to know where IOUG has documented
this function, but I'd still like to know where (if?) Oracle has done
so.
BTW, I
have frequently been a member of IOUG over the past 10 or 11 years, just not at
the present.
Than
Title: RE: AW: Script for reversing a string?
If you were a member of the international oracle users
group, you would have found this function documented in
the Jan. 2001 issue of Select magizine
R. Matt Adams - GE Appliances - [EMAIL PROTECTED]
Contrary to popular opinion, Unix
Jared,
Well, I've RTFM for 8.1.6 and the SQL Reference doesn't
mention a Reverse() function. However, there is a supplied
PL/SQL Reverse() function in the Utl_Raw package. Is there
a connection? If so, how? If not, are my 8.1.6 docs just
wrong?
Thanks.
Jack
But this is so much easier:
select reverse('reverse') from dual;
A little RTFM goes a long way :)
Jared
On Mon, 12 Mar 2001, Haunschmidt Andreas VASL/FAS wrote:
> Hi!
>
> Here's the function:
> -- snip
> -
> create
Hi!
Here's the function:
-- snip
-
create or replace
function reverse_string(iText in varchar2)
return varchar2 is
oText varchar2(2000);
begin
for i in 1 .. least(2000,length(iText))
loop
oText := oText || subs