oracle查询视图触发器等

1.触发器

select name from sysobjects where xtype='TR'

2.存储过程

select name from sysobjects where xtype='P'

3.视图

select name from sysobjects where xtype='V'

4.表

select name from sysobjects where xtype='U'