record count

Select count(*) from your_table_name;

You can have a display item in your form.  After doing execute_query, then you have to code select count(1) into :item_name from table;

Try to use this command.....

INSCNT := sql%rowcount;


which will assign the number of records affected by ur operation to a variable.   You can use this variable to display the number of records affected.The sql%rowcount is a predefined implicit cursor variable frm where you can find the number of records affected by ur operation......

regds

I have tried all the three answers. Thanks for sending but all didn't work.
I don't want to display the number of records in the table.
I want to count the total records display by execute_query for a certian condition. Not all the records displayed.
I tired the thired answer but still it didn't work.