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/
