查某一位使用者所擁有的 Table
2013-07-26 13:42
SQL> set pagesize 100
SQL> column owner format a20
SQL> column OBJECT_NAME format a20
SQL> select owner,object_name from dba_objects where owner='VOIP' and object_type='TABLE';
OWNER OBJECT_NAME
-------------------- --------------------
VOIP VOIPUSER
VOIP FINDME
VOIP CDR
VOIP CALL