This content has been marked as final. Show 2 replies
Hi, try this PL/SQL block. I hope your problem will resolved by this. Revert back with query if any....
set serveroutput on
select count(*) into cnt from DEVCHG.REFRESH_TBL_LIST;
IF SQL%FOUND THEN
DBMS_OUTPUT.PUT_LINE('Total count of table is ' || cnt);
DBMS_OUTPUT.PUT_LINE('No record found');