Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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µÄ×¢²á±í

ÒýÓÃ
sql developer ÖÐÊ×Ñ¡Ïî,ÓÐÒ»¸öÑ¡ÏîÖÐÓÐÒ»¸öÔÊÐí UNICODE ÊÔÒ»ÊÔ¿´



ÎÒÔÚÊ×Ñ¡ÏîÖÐûÕÒµ½ÔÊÐí UNICODE £¬ÄܾßÌå˵һÏÂÔÚʲôλÖÃÂð£¿

ÔÚ¹¤¾ßÖÐ

LZ oracle9i×Ö·û¼¯ÎªÊ²Ã´²»Ê¹ÓÃutf8ÄØ£¿

ÒýÓÃ
ÔÚ¹¤¾ßÖÐ


ÎÒÔÚ¹¤¾ß---Ê×Ñ¡Ïîϵĸ÷¸öÅäÖö¼¿´ÁË£¬Ã»ÓÐѽ

Êý¾Ý¿â×Ö·û¼¯ÓÃ16gbk
¹ú¼ÒÇøÓò×Ö·û¼¯ÓÃutf-8


ÀúÊ·ÒÅÁôÔ­ÒòÖ»ÄÜÓÃAMERICAN_AMERICA.WE8ISO8859P1 £¬¹Ø¼üÊÇÔÚsqlplusºÍpbÖÐÏÔʾ¶¼Õý³££¬Ö»ÊÇÔÚsql developer ÖÐÏÔʾÂÒÂë

ºÃÌù ºÇ

ÂÒÂë°¡

ûÈËÖªµÀÔõôÐÞ¸ÄÂð?

WE8ISO8859P1±¾ÉíÊDz»Ö§³ÖÖÐÎĵÄ
µ«ÊÇÓÐÀýÍâµ


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º

An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48:    ......

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎŪÄØ?Çë´ó¼ÒÊÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ