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

oracle¸Ä×Ö·û¼¯

. ¼´½«µ¼³ö SCOTT µÄ±íͨ¹ý³£¹æÂ·¾¶...
. . ÕýÔÚµ¼³ö±í                          BONUSµ¼³öÁË          0 ÐÐ
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
. . ÕýÔÚµ¼³ö±í                            DEPTµ¼³öÁË          4 ÐÐ
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
. . ÕýÔÚµ¼³ö±í                            EMPµ¼³öÁË          14 ÐÐ
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£
. . ÕýÔÚµ¼³ö±í                        SALGRADEµ¼³öÁË          5 ÐÐ
EXP-00091: ÕýÔÚµ¼³öÓÐÎÊÌâµÄͳ¼ÆÐÅÏ¢¡£

×Ô¼º»úÆ÷ÉÏ×°µÄORACLEÊý¾Ý¿â,µ±Ê±ÉèÖõÄ×Ö·û¼¯ÊÇUTF-8,
µ¼³öʱ³öÏÖÁËÒÔÉϵÄÔ­Òò,ÎÊÁËÒ»ÏÂÓ¦¸ÃÊÇ×Ö·û¼¯ÎÊÌâ,
×¢²á±íÖÐNLS_LANGµÄÖµÊÇSIMPLIFIED CHINESE_CHINA.ZHS16GBK
SYS²éѯ SELECT * from V$NLS_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';
ËùµÃµÄÖµÊÇAL32UTF8
ÎÒ¸ÄÁË×¢²á±íµÄµÄֵΪÕâ¸öÖµ·¢ÏÖSCOTTÓû§¶¼µÇ²»ÉÏ

ÏÖÔÚµÄÎÊÌâ¾ÍÊÇ,ÎÒÈç¹û²»ÖØ×°ORACLEÈçºÎÉèÖÃ×Ö·û¼¯ÎªGBK?
Èç¹û²»¸Ã×Ö·û¼¯ÎÒÔõôÄܳɹ¦µÄµ¼³öÄØ?


set NLS_LANG=american_america.AL32UT


Ïà¹ØÎÊ´ð£º

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

OracleÈçºÎʹÓô°¿Úº¯ÊýʵÏÖÕâÑùµÄ²éѯ

±í¼Ç¼
======================================
name        date        score
Fei Zhang  1          100
Fei Zhang  ......

Ò»Ä깤×÷¾­Ñ飬ÊìϤoracleÖ麣ÕÒ.net¹¤×÷Òª¶àÉÙ¹¤×Ê£¿

ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼

Ö麣ÄDZßËÆºõûÉîÛÚºÃ.

Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ