oracle数据库有哪些对象
这问得太笼统了,友情帮顶.
这是一个大问题，很大的问题。
帮顶......
------------------------------------------------------------------------------
Blog： http://blog.csdn.net/tianlesoftware
网上资源： http://tianlesoftware.download.csdn.net
相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群：62697716(满); DBA2 群：62697977
SQL code:
select * from dba_objects;
Schema Objects
Clusters, Constraints, Database links, Database triggers, Dimensions, External procedure libraries,
Index-organized tables, Indexes, Indextypes, Java classes, Java resources, Java sources,
Materialized views, Materialized view logs, Mining models, Object tables, Object types, Object views,
Operators, Packages, Sequences, Stored functions, stored procedures, Synonyms, Tables, Views
Nonschema Objects
Contexts, Directories, Editions, Restore points, Roles, Rollback segments, Tablespaces, Users
SQL code:
--先看看字典表里的这个
select distinct t.OBJECT_TYPE from dba_objects t;
表、视图、触发器、存储过程、角色、数据库、实例、用户、规则�
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
