Обсуждение: Obtaining nTuples from a cursor

Поиск
Список
Период
Сортировка

Obtaining nTuples from a cursor

От
Michael Dunn
Дата:
I would like to know if there is a way to return nTuples for a cursor
without having to FETCH ALL from the cursor.  I am sorting over 500k
records and growing.. and return 1k at time from the cursor.  But, It I
also need to obtain the total number of records in the cursor without
having to either do a SELECT count(*) of the same query or returning ALL
from the cursor.  It is entirely innefficient...

Regards, Michael