Posts By malcolm

List tables owned by a user

, , No Comment

To show all the tables owner by a specific user. SET SERVEROUTPUT ON SIZE 1000000 BEGIN FOR tble IN (select table_name from dba_tables where owner=’AUSER’) LOOP BEGIN DBMS_OUTPUT.PUT_LINE (tble.table_name); END; END LOOP; END;

Read Post →