Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Block Rows

Re: Block Rows

From: QuadTwin <quadtwin_at_aol.com>
Date: 1997/05/09
Message-ID: <19970509235400.TAA19083@ladder01.news.aol.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US