I am pleased to announce DBD::Sprite, v. 0.24! This new release fixes some minor bugs and adds many new Oracle functions, namely subsets of "TO_CHAR", and "TO_NUMBER". Here is the changes from the "Changes" file:
0.24 Fri Oct 26 - Added new regex feature to allow one to capture regex matches and update field values, ie: update MYTABLE set FIELD1 = '$1' where FIELD2 =~ '(\d+)' This will set FIELD1 to the 1st number found in FIELD2 in the same record. Up to 2 matches for each "where" expression containing "=~" or "!~" may be captured. $1 .. $n correspond to each set of unescaped parenthesis from left to right in the "where" clause. - Added TO_CHAR function for converting Perl "time" values to printable formats. Has most date and numeric functions in the two-argument form of the Oracle "TO_CHAR" function, which it is designed to emulate. - Added some optimization for mass-updates. - Added many other new Oracle functions (TO_NUMBER, USER, ABS, COS, EXP, FLOOR, MOD, POWER, ROUND, SIGN, SIN, TAN, TRUNC, CHR, INITCAP, LTRIM, REPLACE, RTRIM, TRANSLATE, ASCII, LENGTH, SYSDATE. All should now work when selected from "DUAL". Enjoy! Jim Turner __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/