Need to know how to load a variable in a sub select statement. Example: select table list from all_tables with a subselect statement to embed the table name int a select count statement.
Example select table_name from all_tab;es where owner like'lawtest9%'
(select count(*) from lawtest9.&tablename)
then out put the table name and its associated record count into a list exported tro Excel.