oracleÖÐÎÄÂÒÂëÒÉÎÊ¡£¡£
ORALCE8£¬Ò»¸öÒѾ´æÔڵĿ⣬ÎÒÁ¬½Ó×öÍøÕ¾¿ª·¢¡£ ¸Õ×°ºÃµÄʱºòÖÐÎÄÏÔʾÂÒÂ룬Ȼºó°´ÕÕ´ó¼Ò˵µÄ¸ÄÁË×¢²á±íÀïÃæµÄnls_lanΪUS7ASCIIºó toadÁ´½Ó²éѯÏÔʾÖÐÎÄÕý³£¡£ ÏÖÔÚÓÃVS2008¿ª·¢£¬Êý¾Ý°ó¶¨³öÀ´ÏÔʾµÄʱºò¾Í»¹ÊÇÂÒÂëÁË£¬ÕâÎҾ͸㲻Ã÷°×ÁË¡£¡£¡£ ÐÂÊÖ¸Õѧoracle£¬»¹Çë´ó¼ÒÖ¸µãһϡ£¡£¡£
alter session set NLS_LANGUAGE = 'SIMPLIFIED CHINESE'; Õâ¸öÊǸÄÄÄÀïµÄnls_lanµÄ°¡£¿ÎÒÀïÃæÉèÖõͼÊÇUS7ASCII°¡ ¡£¡£¡£ÉèÖÃΪ'SIMPLIFIED CHINESE'ºó»á²»»á¸ü²»Õý³£°¡ Êý¾Ý¿âÀïÃæµÄ û¹ØÏµµÄ Ö»ÊǸıäÒ»ÏÂÊý¾Ý¿âµÄsession¶øÒÑ ÄãÏÈÊÔÊÔ°É ÄãµÄÎÊÌâËÆºõÓëÊý¾Ý¿âµÄ¹ØÏµ²»´óÁË Ã²ËÆvsµÄÎÊÌâÒýÓà alter session set NLS_LANGUAGE = 'SIMPLIFIED CHINESE'; ͬÒâ´Ë·½·¨ ¶Ôvs2008²»Á˽⣬²»¹ýÎÊÌâÓ¦¸ÃÊdzöÏÖÔÚÕâÀï ¿´¿´Äã°ó¶¨Êý¾ÝµÄ·½Ê½ÊÇÔõÑùµÄ£¬ÓÐûÓÐÉèÖÃ×Ö·û¼¯µÄÑ¡ÏÐÞ¸ÄÓ¦¸ÃºÍ×¢²á±íÀïÖµÒ»ÑùµÄ¡£ ǰ¶ËµÄ±àÂë¸ñʽÎÊÌ⣬Êý¾Ý¿âÊÇascii, Ó¦ÓöË×îºÃÒ²¸Ä³ÉasciiµÄ±àÂë ÉèÖÃoracleÊý¾Ý¼¯ÎªÖÐÎļ´¿É ½áÌù ²Î¿¼... http://liushuai-238.javaeye.com/blog/362610
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
Á½¸ö±í Çë¿´ "Persons" ±í£º name banji shunxu yiyang 01 1 yiyang 02 1 lili 01 2 ½ÓÏÂÀ´Çë¿´ "xueke" ±í£º name kemu shunxu yiy ......