Çë½ÌORACLE UTF8ÎÊÌâ
Êý¾Ý¿âÖÐÖÐÎÄÊÇÕý³£µÄ¡£³ÌÐò¶Á³öÀ´£¬ÏÔʾÔÚ¿ØÖÆÌ¨£¬ÊÇÂÒÂë¡£ÇëÎÊʲôÔÒò£¿¶àл
·þÎñÆ÷¶ËºÍ¿Í»§¶ËµÄ×Ö·û¼¯·Ö±ðÊÇʲô£¿ ¾ÍÊÇÔÚ·þÎñÆ÷¿ØÖÆÌ¨´òÓ¡³öÀ´µÄ£¬´ÓÊý¾Ý¿âÖжÁ³öÀ´µÄÖÐÎÄÏÔʾ¾ÍÊÇÂÒÂ룬ֱ½ÓÔÚ³ÌÐòÖеÄÖÐÎÄÏÔʾÕý³£ ÔÚ¶ÁÈ¡Êý¾ÝµÄʱºòÊÇ·ñÒª×öÊ²Ã´ÌØÊâ´¦Àí£¿ÒýÓà ÄãµÄ¿Í»§¶Ë×Ö·û¼¯ºÍ·þÎñÆ÷µÄ²»Ò»ÑùÔì³ÉµÄ,ÐÞ¸ÄÄãµÄ¿Í»§¶Ë×Ö·û¼¯ ÐÞ¸Äoracle¿Í»§¶Ë×Ö·û¼¯£¨±àÂ룩 ¹Ø¼ü×Ö: ÐÞ¸Äoracle¿Í»§¶Ë×Ö·û¼¯£¨±àÂ룩 1.´ò¿ª×¢²á±í-regedit 2.ÕÒµ½ÈçÏÂĿ¼£º HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> KEY_OraDb10g_home1 3.Ö´ÐÐsql¡¡ ²»Éæ¼°µ½¿Í»§¶Ë°¡¡£Êý¾Ý¿â¡¢³ÌÐòÔËÐзþÎñÆ÷¶¼ÊÇͬһ̨·þÎñÆ÷
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
Á½¸ö±í Çë¿´ "Persons" ±í£º name banji shunxu yiyang 01 1 yiyang 02 1 lili 01 2 ½ÓÏÂÀ´Çë¿´ "xueke" ±í£º name kemu shunxu yiy ......
ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£» select * from (select * from table order by col_name desc) where rownum<=3; select * from ( select s.*,rownum rn from t3 s ) where ......