Hi,

What is the diference between
1) select count(*) into cnt from bigtable;

2) select col1,col2,col3... from bigtable;
cnt := sql%rowcount;

Are these variants equals or not ?

is it true, that sql%rowcount returns only amount of fetched dataset and not of whole result dataset ?


Thanks a lot