17,377
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
liuyi8903 2004-12-11
- 打赏
- 举报
Select Distinct a.Object_Name, b.Tablespace_Name, a.Owner, a.Object_Type
From All_Objects a, All_All_Tables b
Where b.Tablespace_Name = 'LIUYI'
And a.Owner = b.Owner
And a.Object_Type In ('TABLE', 'VIEW', 'PROCEDURE', 'FUNCTION')
From All_Objects a, All_All_Tables b
Where b.Tablespace_Name = 'LIUYI'
And a.Owner = b.Owner
And a.Object_Type In ('TABLE', 'VIEW', 'PROCEDURE', 'FUNCTION')
dinya2003 2004-12-11
- 打赏
- 举报
select * from all_tables t where t.tablespace_name='表空间名大写'
SELECT * FROM ALL_TAB_COLUMNS T WHERE T.TABLE_NAME='表名大写';
SELECT * FROM ALL_TAB_COLUMNS T WHERE T.TABLE_NAME='表名大写';
