Hi,
I am using the below to get the list of table names in a DB:-
for i in ( select table_name from user_tables )
loop
….
dbms_output.put_line(Table with Schema: '||i.table_name);
end loop;
Here along with the table name I need to find the schema as well which I need to print, whether it is possible to get the schema from the user_tables? if not how I can append the schema ?