Çë½ÌORACLE UTF8ÎÊÌâ
Êý¾Ý¿âÖÐÖÐÎÄÊÇÕý³£µÄ¡£³ÌÐò¶Á³öÀ´£¬ÏÔʾÔÚ¿ØÖÆÌ¨£¬ÊÇÂÒÂë¡£ÇëÎÊʲôÔÒò£¿¶àл
·þÎñÆ÷¶ËºÍ¿Í»§¶ËµÄ×Ö·û¼¯·Ö±ðÊÇʲô£¿ ¾ÍÊÇÔÚ·þÎñÆ÷¿ØÖÆÌ¨´òÓ¡³öÀ´µÄ£¬´ÓÊý¾Ý¿âÖжÁ³öÀ´µÄÖÐÎÄÏÔʾ¾ÍÊÇÂÒÂ룬ֱ½ÓÔÚ³ÌÐòÖеÄÖÐÎÄÏÔʾÕý³£ ÔÚ¶ÁÈ¡Êý¾ÝµÄʱºòÊÇ·ñÒª×öÊ²Ã´ÌØÊâ´¦Àí£¿ÒýÓà ÄãµÄ¿Í»§¶Ë×Ö·û¼¯ºÍ·þÎñÆ÷µÄ²»Ò»ÑùÔì³ÉµÄ,ÐÞ¸ÄÄãµÄ¿Í»§¶Ë×Ö·û¼¯ ÐÞ¸Äoracle¿Í»§¶Ë×Ö·û¼¯£¨±àÂ룩 ¹Ø¼ü×Ö: ÐÞ¸Äoracle¿Í»§¶Ë×Ö·û¼¯£¨±àÂ룩 1.´ò¿ª×¢²á±í-regedit 2.ÕÒµ½ÈçÏÂĿ¼£º HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> KEY_OraDb10g_home1 3.Ö´ÐÐsql¡¡ ²»Éæ¼°µ½¿Í»§¶Ë°¡¡£Êý¾Ý¿â¡¢³ÌÐòÔËÐзþÎñÆ÷¶¼ÊÇͬһ̨·þÎñÆ÷
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£» select * from (select * from table order by col_name desc) where rownum<=3; select * from ( select s.*,rownum rn from t3 s ) where ......