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 = '表空间' And a.Owner = b.Owner And a.Object_Type In ('TABLE', 'VIEW', 'PROCEDURE', 'FUNCTION')
SELECT T.COLUMN_NAME FROM ALL_TAB_COLUMNS T WHERE T.TABLE_NAME='表名大写';
From All_Objects a, All_All_Tables b
Where b.Tablespace_Name = '表空间'
And a.Owner = b.Owner
And a.Object_Type In ('TABLE', 'VIEW', 'PROCEDURE', 'FUNCTION')
自己去看看这写表
已知存储过程名称怎样获取输出参数名称
(SQLSERVER 以上都可以)