RE: AW: Script for reversing a string?

2001-03-14 Thread jkstill
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 >

RE: AW: Script for reversing a string?

2001-03-14 Thread Adams, Matthew (GEA, 088130)
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

RE: AW: Script for reversing a string?

2001-03-13 Thread Jack C. Applewhite
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

RE: AW: Script for reversing a string?

2001-03-13 Thread Adams, Matthew (GEA, 088130)
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

RE: AW: Script for reversing a string?

2001-03-13 Thread Jack C. Applewhite
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

Re: AW: Script for reversing a string?

2001-03-13 Thread jkstill
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

AW: Script for reversing a string?

2001-03-12 Thread Haunschmidt Andreas VASL/FAS
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