oracle数据字典

--数据字典视图：

--查看数据库对象
select * from user_objects
 where object_name = 'SIMPLE'
 
--查看源码
select *  from user_Source
 where name = 'SIMPLE'
 
--查看错误信息
select *  from user_errors
 where name = 'SIMPLE'

--字段数
select *  from user_tab_columns
 where table_name='SD_SALEBILLLIST'

--

select * from v$instance
select * from v$session
select * from v$parameter  where name='global_names'