ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒÏëѧϰoralceµÄ»ù´¡ÖªÊ¶£¬ÏëÎʸ÷λ´óÏÀ£¬ÏÂÔØoracleµÄÄĸö°æ±¾ºÏÊÊ,ÎÒ¸öÈËÏëÏÂÔØoracle 10 express°æ£¬ÔõôÑù£¿
±ê×¼°æºÍÆóÒµ°æ¶¼ÐÐ expressÕâ¸öÊÇʲô°æ±¾£¬ÎÒÔÚoracleÍøÕ¾ÉÏ¿´¸öexpressҪСЩ£¬ËùÒÔÎÒÏëÏÂÔØÕâ¸ö°æ±¾£¬ÔõôÑù£¿ 10.2µÄÆóÒµ°æ£¬¶ÔOracleÀ´Ëµ£¬ÓÀÔ¶²»ÒªÏÂÔØexpress°æ¡£ ÏÂÔÚOracle 10g °æ±¾µÄ¡£ ¹ÙÍøÃâ·ÑÏÂÔØ£¬¡°Ãâ·ÑʹÓá± ÏÂÔØµØÖ·£º http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------------------------------------------ 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 ÎÒÒ²ÊÇÐÂÊÖ£¬ÎÒÓõÄÊÇoracle9¡£02£¬¸Ð¾õµ½»¹²»´í oracle10GµÄ»¹²»´í Oracle 10.2.0 Express ×Ô¼ºÓÃÓÿÉÒ﵀ ¹ÙÍøÃâ·ÑÌṩÏÂÔØ ×Ô¼ºÒ»Ö±ÔÚÓà ûʲôÎÊÌâ¶øÇÒ°²×°ÎļþС¡¢Õ¼ÄÚ´æÉÙ 10.2.0.1.0 enterprise ¹ÙÍøÏ¡£ ¶¼ÊÇÃâ·ÑµÄ¡£ ÄǸöExpress½¨Òé²»ÒªÓ㬸öÈ˾õÐкÍÕýʽµÄ²î±ð²»ÊÇ挻´óµÄ£¬ ÈÝÒ×Ôì³ÉExpressÓûáÁË£¬Ò»µ½ÕýʽµÄ»¹¾³É¶¶¼ÕÒ²»µ½ÁË express°æÓÐʲô²î±ð£¿ ½¨ÒéʹÓÃoracle11g 10g Ŷ£¬ÎÒÏëѧЩ»ù´¡µÄ£¬Èç¹ûÓÐÌõ¼þÔÙÉîÈë¡£ÄÇÎÒ¼ÒÀï×°ÁËvs,ms sql,µçÄÔÅäÖÃÊÇË«ºË£¬1g£¬µ½Ê±°²×°ºó»á²»»áºÜ¿¨£¿¶ÔÁË£¬Äǰ²×°±ê×¼»¹ÊǸöÈ˰æºÏÊÊЩ£¿ÒýÓà Ŷ£¬ÎÒÏëѧЩ»ù´¡µÄ£¬Èç¹ûÓÐÌõ¼þÔÙÉîÈ
Ïà¹ØÎÊ´ð£º
ÓÃ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
......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡ °²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖᣠµã»÷½øÈ룺Database Configuration Assistant 1. ´´½¨Êý¾Ý¿â£»
......
select distinct '1' t1,'2' t2,'3' t3,'4' t4 from table ²é³öÀ´µÄ½á¹ûΪ 1,2,3,4 ÎÒÏëµÃÒÔÏÂÕâÑùµÄЧ¹û 1 2 3 4 ÇëÎÊÒ»ÏÂÓÐʲô°ì·¨¿ÉÒÔ½â¾ö??? ûÓкõķ½·¨£¬ÓÃunion£¬Ò»ÌõÌõ¼Ç¼ƴ½Ó SQL code: wi ......