ORACLEÌí¼Ó¼Ç¼ÎÊÌâ
°æ±¾ÊÇ9I£¬ÓÃEnterprise Manager Console£¬½¨ÍêÁ˱í¿Õ¼ä£¬Óû§£¬·½°¸ÕâЩ,È»ºóJSPÒ²ÁªÉÏÁË£¬µ½Ö¹È«ÎªÊó±ê²Ù×÷,È»ºóÌí¼Ó¼Ç¼ÔõôҲÕÒ²»µ½£¬Ï°¹ßÁËMSSQL»òACCESSË«»÷Ò»ÕűíÈ»ºóÖ±½ÓÍùÀïÌîÊý¾ÝÇåÎúÖ±¹Û£¬ORACLEÄѵÀÒ»¶¨ÒªÓÃSQLÓï¾ä²ÅÄܼӼǼÂ𣿣¨×¢£¬ORACLEÎÒûÓа²×°¿Í»§¶Ë£¬Ö±½ÓÔÚ±¾»úÉϲÙ×÷µÄ£©
½¨ÒéÓÃа汾µÄoracleѧϰ£¬
ÎÒÓõľÍÊÇoracle11g£¬
¹¤¾ß±È½ÏÈ«£¬²Ù×÷Ò²·½±ã
Ïà¹ØÎÊ´ð£º
±¾À´ÒªÐ´¸ö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 ......
´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......