Please help me to this PL/SQL command. I want to count(*) from table i got on DEVCHG.REFRESH_TBL_LIST.
for tbl in (
select table_name from DEVCHG.REFRESH_TBL_LIST
select count(*) into cnt from tbl;
This is probably best asked in the [url http://forums.oracle.com/forums/forum.jspa?forumID=75]PL/SQL forum, but you are on the right track.
Replace your select into with some dynamic SQL
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');