Oracle Forms :- Steps to get record counts in Data block without saving the records

Steps to get record counts in Data block without saving the records in Oracle Forms :- 

While developing the Custom Oracle Forms, We will populate the records into the line level data blocks with using of Fetch Cursor. If we need to count the fetched records in the data block without saving the records, we will count the records in two different methods 

1. Query Hits - Oracle Forms Block Property. 

2. Manual Method using Go_block function.

In this below Screen shot shows the Line level fetched data in the Custom form in Oracle.

1. Query Hits - Oracle Forms Block Property. 

TOT_REC_COUNT := GET_BLOCK_PROPERTY('BLOCK_NAME', QUERY_HITS);

2. Manual Method using Go_block function.

GO_BLOCK('BLOCK_NAME');

First_record;

last_record;

TOT_REC_COUNT := GET_BLOCK_PROPERTY('BLOCK_NAME',current_record);