ÏÂÔØoracleÌØ±ð°æ£¨Í¨Óð棩 - Oracle / »ù´¡ºÍ¹ÜÀí
http://www.oracle.com/technology/global/cn/software/products/database/xe/htdocs/102xewinsoft.html
ÊÇÔÚÕâ¸öÁ´½ÓÏÂÔØÂð£¬ÈçÏ£º
Oracle Êý¾Ý¿â 10g ÌØ±ð°æ£¨Í¨Óð棩
OracleXEUniv.exe£¨216,933,372 ×Ö½Ú£©
Õë¶ÔËùÓÐÓïÑÔ²¿ÊðµÄ¶à×Ö½Ú Unicode Êý¾Ý¿â£¬¸ÃÊý¾Ý¿âÖ÷Ò³µÄÓû§½çÃæ¿ÉÒÔʹÓÃÒÔÏÂÓïÑÔÏÔʾ£º°ÍÎ÷ÆÏÌÑÑÀÎÄ¡¢ÖÐÎÄ£¨¼òÌåºÍ·±Ì壩¡¢Ó¢ÎÄ¡¢·¨ÎÄ¡¢µÂÎÄ¡¢Òâ´óÀûÎÄ¡¢ÈÕÎÄ¡¢º«ÎĺÍÎ÷°àÑÀÎÄ¡£
¸Õ¸Õ½Ó´¥oracle£¬Ïë°²×°ÔÚwin7Ï£¬Õâ¸ö°æ±¾¿ÉÒÔÂð£¬Ð»Ð»£¡
Ö÷ÒªÓÃÁ˳õ¼¶Ñ§Ï°and²âÊÔ¡£¡£¡£
·Ç³£¸Ðл¡£ºÇºÇ¡£
´ËÁ´½Ó£ºhttp://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10203vista.html
32λµÄ10.2.0.3/£¬Ã²ËÆ»¹ÒªÏÂÔØ°²×°10.2.0.4²¹¶¡¡£OK¡£¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......