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

"Alan" <alan_at_erols.com> wrote:

>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|
>>
>>
>

Any ideas, rumors, etc about why such a function exists ( were Oracle coders bored one day?) Received on Thu Mar 18 2004 - 15:17:53 CST