表 :select object_name from user_objects where object_type='TABLE';
视图:select object_name from user_objects where object_type='VIEW';
存储:select object_name from user_objects where object_type='PROCEDURE';
触发器:select object_name from user_objects where object_type='TRIGGER';
序列器:select object_name from user_objects where object_type='SEQUENCE';
索引:select object_name from user_objects where object_type='INDEX';
数据链路:select object_name from user_objects where object_type='DATABASE LINK';
视图:select object_name from user_objects where object_type='VIEW';
存储:select object_name from user_objects where object_type='PROCEDURE';
触发器:select object_name from user_objects where object_type='TRIGGER';
序列器:select object_name from user_objects where object_type='SEQUENCE';
索引:select object_name from user_objects where object_type='INDEX';
数据链路:select object_name from user_objects where object_type='DATABASE LINK';
问上几个问题没玩ORACLE,问几个最想问的问题:
怎么样看到ORCLE里面的表,视图,存储过程。
Try the powerbuider 8 ,if you hava
or use plsql developer,that's my likely,
if you want find some objects on your writed,please use
select * from all_objects,then the useful table,views,proceur will on your eyes.
这两个最好用了。
我个人建议如果你选择TOAD、PL/SQL Developer,这两个是几乎所有学Oracle的人都会装的。
OEM当然也很好用,但是9i中用的多,10g就改成web版了,反应不是很快。
另外建议你学学基础和数据字典,你用过很多工具就知道GUI的外壳不是最重要的,很多时候也许你手头只有sql plus。
至于PB8,如果只是为了看看oracle还要装个PB8,未免过分了
第三方工具:PLSQL Developer,TOAD