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;
±í¡¢ÊÓͼ¡¢´¥·¢Æ÷¡¢´æ´¢¹ý³Ì¡¢½ÇÉ«¡¢Êý¾Ý¿â¡¢ÊµÀý¡¢Óû§¡¢¹æÔò¡
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
±¾ÈËÏÖÔÚѧoracle ËãÊǸոÕÈëÒ»°ëÃÅ ÒÔºó»¹ÒªÑ§java ¸÷λ´óÏÀoracleºÃÈëÊÖ»¹ÊÇjavaºÃÈëÊÖ°¡ ÒÔºóÄǸö·½Ãæ·¢Õ¹»áºÃЩ
£¬ÎÒÔÝʱÓиöÏë·¨ÏëºÃºÃѧϰһÏÂÊý¾Ý¿âÒÔºóÍùÕâ·½±ã·¢Õ¹£¬±Ï¾¹Êý¾Ý¿â¸úл»´úûÓÐjavaÄÇô¿ì£¬²» ......