DOAQuery Recordcount

[Vinu Vishnu]

Hi All,
I have an application that needs to create an excel sheet from db records. Since the record count is huge, the application needs to split the data into multiple tabs. So, I need to get the record count immediately after the query execution so that I can determine the number of tabs in advance to improve the performance. I am using an old OCI version which does not support scrollable result sets. Since my query is large having many join conditions, I don't want to run a "SELECT COUNT(*)" to know the record count. Please guide me if there is any alternative method available.
thanking you all,
Vinu

 

[Marco Kalter]

Doing a "select count(*)" is the only option to know the number of records beforehand. There are of course some client-side alternatives. You could for example first write the result set to a temporary file and then, knowing the result set size, read from the file to create the excel sheet.

 

[Vinu Vishnu]

Thank you...