Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

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

ÎÒ°²×°ÁËoracle 10g¾­¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ