Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

string compression

Mrshah-OracleJul 2 2012 — edited Jul 3 2012
Hi,

We are looking for some method to compress string in PL/SQL, Is there any string compression method/package available?

We tried function utl_compress.lz_compress which compressed the BLOG field, but the storage space was increased by 300%... (checked dba_extents)

Can someone please suggest some better way to compress strings..

Thanks and Regards!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2012
Added on Jul 2 2012
7 comments
695 views