jdbcÁ¬½ÓOracle
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬ÔÚdaoÖÐдºÃÁËÁ¬½Ó£º
È»ºóдºÃÁ˲éѯҳÃ棺
ÔÙдºÃservlet£¬µ±È»ÎÒµÄbeanÊÇ֮ǰ¾ÍдºÃµÄ£¬ºÜ¼òµ¥£¬ºÜÈÝÒ×Àí½â£¬Ò²¾Í²»ÔÚÕâÀïչʾ£¬ºÙºÙ£¡
×îºóÔÙдºÃ²éѯÓï¾ä£¬µ±È»£¬Õâ¸ö¶«¶«Ò²ÊÇÔÚdaoÖÐд¡£
дÍêÕâЩ»ù±¾×¼±¸Ö®ºóÎҾͿªÊ¼µ÷ÊÔÀ²£¬ºÙºÙ¡£
µ«ÊÇ£¬µ±Í·Ò»°ô£¬ÂíÉÏÓöµ½Ò»¸ö´íÎó£º
È»ºó£¬¾ÍÊÇ·è¿ñµÄÉÏÍø²éÕÒ£¬ºÙºÙ£¬ºÃÐÄÈ˺ܶ࣬Ȼºó¾Í½â¾öÎÊÌ⣬½â¾ö²½ÖèÈçÏ£º
1¡¢Ê×ÏÈ¿´URLºÍ¶Ë¿ÚÊÇ·ñ´íÎó
¾¼ì²é£¬Oracle·þÎñÊÇ¿ªÆôµÄ£¬Êý¾Ý¿âÊÇÆô¶¯µÄ£¬ãç¿ÚÒ²ÊÇÕýÈ·µÄ£¬µ±È»IP¾Í²»ÓÃ˵À²¡£
2¡¢¼ì²éÊÇ·ñÊÇÒòΪ·À»ðǽµÄÔÒò½«¶Ë¿Ú×èÖ¹¿©£¬È»ºóÖØÆô£¬½á¹û»¹ÊÇʧ°Ü
3¡¢¼ì²éÊý¾Ý¿â¼àÌýÊÇ·ñ¿ªÆô
¿ªÊ¼ → ÔËÐÐ→ ÊäÈëCMD→ ½øÈëDOSÃüÁîÌáʾ½çÃæÇÃÈ룺
lsnrctl½øÈë
È»ºó²é¿´×´Ì¬ÊÇ·ñ¿ªÆô£ºLSNRCTL>status,µÃµ½
Õâ¾ÍÖ¤Ã÷ÁË£¬Êý¾Ý¿â¼áͦûÓдò¿ª£¬µ±È»£¬Á¬½ÓÊý¾Ý¿â¾ÍÊDz»µÃ³É¹¦µÄ£¬½ÓÏÂÀ´¾Í´ò¿ªÊý¾Ý¿â¼àÌý
ºÙºÙ£¬ÒªÊÇÏÔʾµ½ÕâÒ»²½£¬ÄÇôÁ¬½ÓÊý¾Ý¿âÒ²¾Í³É¹¦À²£¡
Ò²µ±È»À²£¬½ñÌìµÄÁ¬½Ó¾Í³É¹¦ÁË£¬ºÙºÙ£¡£¡£¡
Ïà¹ØÎĵµ£º
OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ ......
Ç¿ÖÆÇл»ÖØ×öÈÕÖ¾
ALTER SYSTEM SWITCH LOGFILE; Ç¿ÖƲúÉú¼ì²éµã
ALTER SYSTEM CHECKPOINT; ¼ä½Ó²úÉú¼ì²éµã(É趨ʵÀý»Ö¸´Ê±¼ä²»³¬¹ýmmÃë,Ò༴ִÐмì²éµãÖ®ºóÔËÐг¬¹ýÕâ¸öʱ¼ä¾ÍÔÙ´ÎÖ´Ðмì²éµã)
ALTER SYSTEM SET FAST_START_MTTR_TARGET = ÃëÊý; »ñÈ¡ÖØ×öÈÕÖ¾ÎļþÐÅÏ¢
SELECT group#, ......
-- ±Ê¼ÇÖв¿·ÖÄÚÈÝ
SQL> create table tt2 as select * from employee;
Table created.
SQL> drop table tt2;
Table dropped.
SQL> select * from tt2;
select * from tt2
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> flashback table tt2 to before drop;
Flashback comp ......
±í¿Õ¼ä×ÊÁϲéѯ
SELECT tablespace_name, block_size, extent_management, segment_space_management from dba_tablespaces;
ÅäºÍ
SELECT tablespace_name, initial_extent, next_extent, max_extents, pct_increase, min_extlen from dba_tablespaces;
ÅäºÏ
SEL ......
OracleÌṩWrap¹¤¾ß£¬¿ÉÒÔÓÃÓÚ¼ÓÃÜÄãµÄPackageµÈ.
²»¹ýÐèҪעÒâµÄÊÇ£¬¼ÓÃܺóµÄ´úÂëÎÞ·¨½âÃÜ£¬ÄãÐèÒª±£¹ÜºÃÄãµÄÔ´´úÂë¡£
ÒÔÏÂÊǸöÀý×Ó:
1.Ô´´úÂë
create or replace function get_rowid
(l_rowid in varchar2)
return varchar2
is
ls_my_rowid varchar2(200);
rowid_type number;
ob ......