Re: September's PL/SQL Puzzler!

From: Xlr82sas <xlr82sas_at_aol.com>
Date: 1997/09/13
Message-ID: <19970913132801.JAA08121_at_ladder02.news.aol.com>#1/1

[Quoted] 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 ....

[Quoted]        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