S
S
sitev_ru2015-09-01 09:58:44
Oracle
sitev_ru, 2015-09-01 09:58:44

How to find out the number of rows in Oracle ResultSet C++?

I connect to Oracle from C++. How to get the number of rows in ResultSet?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Skahin, 2015-09-01
@sitev_ru

It seems that in no way, make an infinite grid with loading the next portion of the cursor replacing the classic pagination.
Well, or add to all requests:

SELECT * FROM (
SELECT COUNT(*) OVER() as cnt, ROW_NUMBER() OVER(ORDER BY ...) as rn, ....
) 
WHERE rn BETWEEN :ST AND :ED

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question