Code: select count(*) into v_count from test_abc_prices where rownum = 1; should be faster
select count(*) into v_count from test_abc_prices where rownum = 1;
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Forum Rules