this the example where i fetch data using cursor.I have to put in loop to get the total row count.can any one tell me is ther any way to get total row count with out putting in a loop.
Open cur_fetch;
fetch cur_fetch into v_langrec;
WHILE cur_fetch%FOUND
LOOP
DBMS_OUTPUT.PUT _LINE
('Just fetched record number ' ||
TO_CHAR (cur_fetch%ROWC OUNT));
FETCH cur_fetch INTO v_langrec;
END LOOP;
Open cur_fetch;
fetch cur_fetch into v_langrec;
WHILE cur_fetch%FOUND
LOOP
DBMS_OUTPUT.PUT _LINE
('Just fetched record number ' ||
TO_CHAR (cur_fetch%ROWC OUNT));
FETCH cur_fetch INTO v_langrec;
END LOOP;