Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Block Rows
Gustavo S. Tamaki gstamaki_at_pobox.com wrote:
> How can I count the total "populated" rows in a block ? QUERY_HITS
> don't reflect created rows.
>
> Regards,
See if GET_BLOCK_PROPERTY('block', top_record); works for you. A crude alternative is:
LAST_RECORD reccount := to_numer(:system.cursor_record);
Al Lawson
Interactive Group, Inc.
www.interactive-group.com
lawsona_at_interactive-group.com
Received on Fri May 09 1997 - 00:00:00 CDT
![]() |
![]() |