Query to run Dynamic SQL Using XML on SQL> prompt

Query to run Dynamic SQL Using XML on SQL> prompt

SELECT table_name, extractvalue(dbms_xmlgen.getxmltype('select count(*) from ' || table_name),'//text()')
FROM user_Tables
WHERE table_name LIKE 'A%'

The query above is just sample. Put your query in getxmltype and you are all set.