OraFAQ Forum: Forms » Record Count

Home » Developer & Programmer » Forms » Record Count

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Record Count [message #87226]

Tue, 14 December 2004 15:37

Scoodels
Messages: 8
Registered: November 2004

Junior Member

Hi!!

Could anybody tell how to get the record count retrieved by a query.

Thanks
Scoodels

Report message to a moderator

Re: Record Count [message #87229 is a reply to message #87226]

Tue, 14 December 2004 20:10

Riaz
Messages: 112
Registered: February 2002

Senior Member

se get_block_property('blockname',query_hits) and assign it to a variable of your choice..

Riaz

Report message to a moderator

Re: Record Count [message #87255 is a reply to message #87229]

Wed, 15 December 2004 13:08

Just John
Messages: 69
Registered: November 2004

Member

Thats not quite the whole story.....

From Forms you need to:

PRE_QUERY TRIGGER
--------
COUNT_QUERY;
EXECUTE_QUERY;

ON_COUNT TRIGGER
--------
COUNT_QUERY;
:block.item := GET_BLOCK_PROPERTY('block', QUERY_HITS);

Report message to a moderator

Re: Record Count [message #87256 is a reply to message #87226]

Wed, 15 December 2004 13:14

Just John
Messages: 69
Registered: November 2004

Member

also look at: SQL%ROWCOUNT

set serverout on size 100000

declare
counter number;
begin
update table
set column = 'value';
counter := sql%rowcount;
dbms_output.put_line(counter);
end;

Report message to a moderator

Re: Record Count [message #87263 is a reply to message #87256]

Wed, 15 December 2004 13:49

Just john - what was I t
Messages: 1
Registered: December 2004

Junior Member

use:

SELECT COUNT(*) FROM dual;

SELECT COUNT(*) INTO counter FROM dual;

FOR crec IN (SELECT * FROM dual) LOOP
counter := NVL(counter,0)+1
END LOOP;

any use?

Report message to a moderator

Previous Topic:	text_io problem
Next Topic:	I cannot connect Forms6i to Oracle9i Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 03:42:33 CDT 2024