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
Ïà¹ØÎÊ´ð£º
°²×°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ÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
±í¼Ç¼
======================================
name date score
Fei Zhang 1 100
Fei Zhang  ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿
¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼
Ö麣ÄDZßËÆºõûÉîÛÚºÃ.
Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......