Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLEÌí¼Ó¼Ç¼ÎÊÌâ

°æ±¾ÊÇ9I£¬ÓÃEnterprise Manager Console£¬½¨ÍêÁ˱í¿Õ¼ä£¬Óû§£¬·½°¸ÕâЩ,È»ºóJSPÒ²ÁªÉÏÁË£¬µ½Ö¹È«ÎªÊó±ê²Ù×÷,È»ºóÌí¼Ó¼Ç¼ÔõôҲÕÒ²»µ½£¬Ï°¹ßÁËMSSQL»òACCESSË«»÷Ò»ÕűíÈ»ºóÖ±½ÓÍùÀïÌîÊý¾ÝÇåÎúÖ±¹Û£¬ORACLEÄѵÀÒ»¶¨ÒªÓÃSQLÓï¾ä²ÅÄܼӼǼÂ𣿣¨×¢£¬ORACLEÎÒûÓа²×°¿Í»§¶Ë£¬Ö±½ÓÔÚ±¾»úÉϲÙ×÷µÄ£©


½¨ÒéÓÃа汾µÄoracleѧϰ£¬
ÎÒÓõľÍÊÇoracle11g£¬
¹¤¾ß±È½ÏÈ«£¬²Ù×÷Ò²·½±ã


Ïà¹ØÎÊ´ð£º

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

¶à±í¹ØÁª²éѯµÄ sqlд·¨ - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ