ããæ¹æ³1ï¼
ããæ ¹æ®æå®ç¨æ·åè·å¾å¯¹åºç¨æ·ææ¥ææéç表
ããSELECT table_name, owner FROM all_tables WHERE owner = 'SCOTT';æ¹æ³2ï¼
ããéè¿tabè§å¾è·å¾å½åç»å½ç¨æ·ææ表åè§å¾ï¼éè¿tabletypeè¿æ»¤è·å¾ææ表SELECT * FROM tab WHERE tabtype = 'TABLE';æ¹æ³3ï¼
ããæ ¹æ®user_tables表è·å¾å½åç¨æ·æ¥æææ表
ããSELECT table_name FROM user_tables;
ããæ¹æ³4ï¼
ããæ ¹æ®sys表空é´ä¸all_object表è·å¾æå®ç¨æ·æå®ç±»å对象ï¼è¡¨ï¼SQL> SELECT object_name FROM sys.all_objects WHERE owner='SCOTT' AND object_type='TABLE';
温馨提示:答案为网友推荐,仅供参考