Hi,
what is the best way to check that a table is empty?
I have procedure with the following statement:
then i'm checking whether count(*) >0:Quote:
select count(*) into v_count from test_abc_prices;
Is there a more efficient way?Quote:
if (v_count > 0) then null