oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
2.ÔÚsql plusÖвéѯͬÑùµÄ±í£¬ÖÐÎÄÏÔʾÕýÈ·¡£
3.ÔÚpowerbulider¿ª·¢¹¤¾ßÖвéѯͬÑùµÄ±í£¬ÖÐÎÄÏÔʾҲÕýÈ·¡£
4.»·¾³±äÁ¿ÖÐÉèÖÃÁËnls_lang=AMERICAN_AMERICA.WE8ISO8859P1
5.ÔÚsqlplus¡¢pb¡¢sql developerÈý¸ö³ÌÐòÖ´ÐÐselect * from v$nls_parameters ;
Èý¸ö²éѯÏÔʾµÄ¸÷¸ö²ÎÊýµÄÖµÍêȫһÑù¡£
6.½«sql developer ÖеÄ×ÖÌå¸ÄΪËÎÌ壬ÏÔʾҲΪÂÒÂë¡£
ʵÔÚÕÒ²»³öÔÒòÁË£¬°ï°ïæ°É£¡
sql developer ÖÐÊ×Ñ¡Ïî,ÓÐÒ»¸öÑ¡ÏîÖÐÓÐÒ»¸öÔÊÐí UNICODE ÊÔÒ»ÊÔ¿´
¹Ø×¢
¿´Ò»ÏÂwindowsµÄ×¢²á±í
ÎÒÔÚÊ×Ñ¡ÏîÖÐûÕÒµ½ÔÊÐí UNICODE £¬ÄܾßÌå˵һÏÂÔÚʲôλÖÃÂð£¿
ÔÚ¹¤¾ßÖÐ
LZ oracle9i×Ö·û¼¯ÎªÊ²Ã´²»Ê¹ÓÃutf8ÄØ£¿
ÎÒÔÚ¹¤¾ß---Ê×Ñ¡Ïîϵĸ÷¸öÅäÖö¼¿´ÁË£¬Ã»ÓÐѽ
Êý¾Ý¿â×Ö·û¼¯ÓÃ16gbk
¹ú¼ÒÇøÓò×Ö·û¼¯ÓÃutf-8
ÀúÊ·ÒÅÁôÔÒòÖ»ÄÜÓÃAMERICAN_AMERICA.WE8ISO8859P1 £¬¹Ø¼üÊÇÔÚsqlplusºÍpbÖÐÏÔʾ¶¼Õý³££¬Ö»ÊÇÔÚsql developer ÖÐÏÔʾÂÒÂë
ºÃÌù ºÇ
ÂÒÂë°¡
ûÈËÖªµÀÔõôÐÞ¸ÄÂð?
WE8ISO8859P1±¾ÉíÊDz»Ö§³ÖÖÐÎĵÄ
µ«ÊÇÓÐÀýÍâµ
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8
ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£
½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë
ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.
ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......