¾ÈÃü£ºOracle Select³öÀ´ÂÒÂë - Oracle / »ù´¡ºÍ¹ÜÀí
´ó¼ÒºÃ£¬ÎÒʹÓõÄOraclce10g£¬ÍøÕ¾·þÎñÆ÷×¢²á±íÖÐSIMPLIFIED CHINESE_CHINA.ZHS16GBK£¬Oracle·þÎñÆ÷×¢²á±íÒ²ÊÇSIMPLIFIED CHINESE_CHINA.ZHS16GBK£¬µ«ÊÇselect£¬insert³öÀ´¶¼ÊÇÂÒÂ롣ʹÓÃPLSQLÒ²ÊÇÈç´Ë£¬²»ÖªµÀÊÇΪʲô£¬¸ãÁËÒ»ÌìҲûŪ³öÀ´£¬Çó´ó»ï°ïÖú£¬Ð»Ð»¡£
ÎÒµÄASP.Net¶Á³öÀ´µ¹²»ÊÇÂÒÂ룬¾ÍPLSQLÀïÃæÔö¼ÓÊý¾ÝºÍÐÞ¸ÄÊý¾ÝÊÇÂÒÂë Ó¦¸Ã»¹ÊÇ×Ö·û¼¯²»Ò»ÖµÄÎÊÌâ °ïÄãUP ×Ö·û¼¯²»Ò»ÖÂÒýÓà ×Ö·û¼¯µÄÎÊÌâ¡£¿ÉÒÔÔÚ.net ÖÐתһÏ¡£ System.Text.Encoding.GetEncoding("gb2312").GetString(System.Text.Encoding.GetEncoding("iso-8859-1").GetBytes(row[5].ToString())) ÒýÓà ͨ¹ý¿Í»§¶Ë»ò·þÎñÆ÷¶ËµÄsql*plusµÇ¼ORACLEµÄÒ»¸öºÏ·¨Óû§£¬Ö´ÐÐÏÂÁÐSQLÓï¾ä£º SQL codeselect*from V$NLS_PARAMETERS ×Ó·û¼¯µÄÎÊÌâ È¡³öÀ´ÒÔºóת»»Ò»ÏÂgb2312 chcpµÄ½á¹ûÊÇʲô£¿ ÎÒ現ÔÚÕýÔÚ學Oracle£¬進來學習һϠûÅöµ½¹ý£¬À´Ñ§Ñ§£¬ÒÔºóÓõÄÉÏ ·þÎñÆ÷ºÍ¿Í»§¶ËµÄ×Ö·û²»Ò»ÖÂŶ ÎÒ֮ǰҲÓÐÏÂÔØ¹ý×Ö¼¯²»Í¬µÄ°æ±¾£¬Ò²ÊÇ»áÏñÕâÑù£¬ÄãÔÚÈ¥ÏÂÔØÕýÈ·µÄ°æ±¾¾ÍûÎÊÌâÁË£¬ÁíÒ»¸ö¾Í²Î¿¼crazylaa˵µÄÐÞ¸Ä×Ö¼¯µÄ·½·¨¡£ ·þÎñÆ÷ºÍ¿Í»§¶ËµÄ×Ö·û²»Ò»Ö£¬ÖØÉèÖÃһϼ´¿É¡£ÒýÓà ×Ö·û¼¯µÄÎÊÌâ¡£¿ÉÒÔÔÚ.net ÖÐתһÏ¡£ System.Text.Encoding.GetEncoding("gb2312").GetString(System.Text.Encoding.GetEncoding("iso-8859-1").Get
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
Á½¸öÎļþ1.PC£¬1.inc 1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......