Re: September's PL/SQL Puzzler!

 We understand that you are able to do SW. But are you able to read?
PL/SQL remember ?

Jorge Meirim

Xlr82sas wrote in article <19970913132801.JAA08121_at_ladder02.news.aol.com>...

>I am a SAS programmer and I am often puzzled by the use of Oracle
>specific solutions, when generic 'fourth gen software is available'. The
>code I present here will work against all ODBC compliant databases and in
>addition will work against almost all aother types of data, from multipunch
>column binary, VSAM, Dun & Bradstreet Accountinf files, Census data etc
 ....
>
> chr = 'sator tenet opera rotas'; /* latin phase */
>
> rchr = revers(chr); /* reverse entire string */
>
> substr(chr,3,2) = reverse(chr,3,2); /* inplace reverse */
>
> sound =soundex(chr);
> call play(sound); /* not sure of syntax */
>Roger J DeAngelis
>CompuCraft Inc
>XLR82SAS_at_aol.com ( Accelerate to SAS )
>http://members.aol.com/xlr82sas/utl.html
Received on Sat Sep 13 1997 - 00:00:00 CEST