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

Oracle²åÈëÖÐÎijöÏÖÂÒÂë - Oracle / ¿ª·¢

Oracle²åÈëÖÐÎijöÏÖÂÒÂë
»·¾³£ºsolaris 10
Êý¾Ý¿â£ºoracle 10g
¿Í»§¶Ë£ºPL/SQL Developer(Windows)

ÔÚsolarisÖÐÓÃsqlplus update»òinsertʱÓÃÖÐÎÄ£¬PL/SQL Developer(windows)³öÏÖÂÒÂ룬
ÔÚPL/SQL Developer(windows)ÖÐinsert»òupdateʱ²»»áÂÒÂë¡£
×Ö·û¼¯ÎÊÌâ¡£

ÉèÖÃwindows×Ö·û¼¯ºÍÊý¾Ý¿â×Ö·û¼¯Ò»Ö¡£

ÄãµÄ solarisµÄ²Ù×÷ϵͳ×Ö·û¼¯ÉèÖò»¶Ô
¿ÉÒÔÉèÖÃ×Ö·û¼¯È磺export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
ÉèÖóÉÓëÊý¾Ý¿â¶ÔÓ¦µÄ×Ö·û¼¯

²åÈëµÄÊý¾ÝÓëÊý¾Ý¿âµÄ×Ö·û¼¯²»Æ¥Åä

³ö´í£¬ÕÒ²»µ½`CHINESE_CHINA.ZHS16GBK'°¡
[root@UNIXServer:/]#export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
-bash: export: `CHINESE_CHINA.ZHS16GBK': not a valid identifier


ÒýÓÃ

³ö´í£¬ÕÒ²»µ½`CHINESE_CHINA.ZHS16GBK'°¡
[root@UNIXServer:/]#export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
-bash: export: `CHINESE_CHINA.ZHS16GBK': not a valid identifier


ÒªÓÃË«ÒýºÅ:

export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

»¹ÊÇÂÒÂë°¡
ÔÚsolarisÊäÈëÈçϺó£¬sqlplus²åÈëÖÐÎÄ£¬PL/SQL Developer(windows)»¹ÊÇÂÒÂë°¡
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

°²×°Êý¾Ý¿âʵÀýµÄʱºò£¬ Ñ¡ÔñÕâ¸ö×Ö·û¼¯£º
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

ÄãÒª¿´Ò»ÏÂÄãµÄÊý¾Ý¿âÀïÊÇʲô×Ö·û¼¯£¿
select * from nls_database_parameters t where t.PARAMETER='NLS_CHARACTERSET';

SQL> select * from nls_database_para


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle ¿ÉÊÓ»¯¿´±íÄÚÈÝ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ°²×°ÁËoracle 10g¾­¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......

javaÁ¬²»ÉÏoracle£¿ - Java / Java EE

java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ