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