I have a SQL query which gives a result set and the size is close to a MB.
How can I compress the result set to reduce size which is consumed by other services.
select ID,product,Name,Desc From Products
There is no BLOB columns involved.
utl_compress.lz_compress is meant for CLOB & BLOB columns.
Is there anything else which can compress or zip the dataset in a location?