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!

determining size of sql result set

394610Feb 8 2006 — edited Mar 28 2006

Hi there. I have a quick query. How does one calculate the size of a result set of an SQL query in terms of storage space (kb, mb, etc.) rather than the number of rows. Basically I have a series of SQL select statements and I need to find out how much data is being returned from each individual statement or all statements together. I have been using SQL for quite some time now but have never approached sizes of result sets from this angle. Thanks a lot, Joe.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2006

Added on Feb 8 2006

5 comments

8,309 views