Compression of contents of a Long field 1

[Custom24]

Hi
We have a table which has a long field containing essentially clob (text) information.

The text compresses well by zip.

We'd like to compress the text, and have Oracle do this transparently on insert and select for us, ideally.

Is this at all possible?

The field may or may not have to remain a long - I am not sure yet.

A solution based on PL/SQL or Java triggers might only half work. The problem would be that application connecting to the db might extract the contents of the long by streaming it out, or might just get it in one go (like a regular varchar2 field). The unzip function would therefore need to be duplicated in the application code if this approach were taken.

Thanks for any suggestions.
Mark

Mark

 

[sem]

You may create a view and select from it.

Regards, Dima

http://seminihin.narod.ru

 

[Custom24]

Thank you. I will try it. I did not think of that.

Mark