Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

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

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

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

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔصĽڵ㣺/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

oracle adoÁ¬½ÓÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈÇ°ÓõÄ10gÒ²Óöµ½ÀàËƵÄÎÊÌâ
ʹÓÃmicrosoft ole db pro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ