Iflex PLSQL 10g New Features
Iflex PLSQL 10g New Features
Iflex PLSQL 10g New Features
13-Sep-13 8:46 PM
PL/SQL 10 g
UTL_COMPRESS
UTL_COMPRESS package provides an API to allow compression and decompression of binary data (RAW, BLOB and BFILE). It uses the Lempel-Ziv compression algorithm which is equivalent to functionality of the gzip utility.
-- Initialize both BLOBs to something. l_original_blob:=
TO_BLOB(UTL_RAW.CAST_TO_RAW('1234567890123456789012345678901234567890'));
l_compressed_blob := TO_BLOB('1'); l_uncompressed_blob := TO_BLOB('1'); -- Compress the data. UTL_COMPRESS.lz_compress (src => l_original_blob, dst => l_compressed_blob); -- Uncompress the data. UTL_COMPRESS.lz_uncompress (src => l_compressed_blob, dst => l_uncompressed_blob);
UTL_Compress
13-Sep-13 8:46 PM
PL/SQL 10 g
UTL_MAIL
UTL_Mail
PL/SQL 10 g
Translate between a date and time, and the System Change Number. SCN provide a precise way to see the data as it was at that moment. TIMESTAMP_TO_SCN Returns the SCN associated with that timestamp. SCN_TO_TIMESTAMP Returns the timestamp associated with that SCN.
flashback_fun
13-Sep-13 8:46 PM