查某一位使用者所擁有的 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