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

linux Ï oracleÒ»ÌõsqlÓï¾äÇë½Ì¡£¡£ - Oracle / ¿ª·¢

oracle×°ÔÚlinuxÏ£¬ÎÒÏîÄ¿ÔÚwindowsÏ¡£
select dg_id ,articles from zzb13 where trait_value='¹úÄÚÊг¡'
²é²»µ½¶«Î÷£¬
ÊÇlinuxϺº×ÖµÄÎÊÌâÂ𣿣¨linux-mysql¿ÉÒԵģ©

Äãͨ¹ýv$sql²éÏÂÄãµ½µ×Ö´ÐеÄÊÇʲôÓï¾ä£¬Äã¸øµÄÐÅϢ̫ÉÙ£¬Ö»ÄÜ´ÓÕâÉÏÃæ¿´ÁË£¡

°ï¶¥Ò»Ï¡£

²é¿´Ò»ÏÂÄã¿Í»§¶ËµÄ×Ö·û¼¯Óë·þÎñÆ÷¶ËÊÇ·ñÒ»Ö£¬Èç²»Ò»Ö£¬¿ÉÄܲ鲻µ½¡£
ÔÚ×¢²á±íÖвéѯ¿Í»§¶Ë×Ö·û¼¯£¬ÀàËÆ
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_LANG
ÔÚ·þÎñÆ÷¶Ë²éѯ×Ö·û¼¯
SELECT userenv('language') from dual;

select dg_id ,articles ,trait_value from zzb13 
²éÕâ¸öÄܵõ½ÐÅÏ¢?
ÏÔʾµÄtrait_valueµÄÂÒÂë?

ÒýÓÃ
select dg_id ,articles ,trait_value from zzb13
²éÕâ¸öÄܵõ½ÐÅÏ¢?
ÏÔʾµÄtrait_valueµÄÂÒÂë?

¹Ø¼üÊÇÎÒ¸´ÖƵ½linuxÉÏÃæ¾ÍÂÒÂëÁË£¬
select dg_id ,articles from zzb13 where trait_value='ta^~'(ÂÒÂëÊÇËæ±ãдµÄ)
ÎÒÖ»ÄÜÊÇÔÚÏîÄ¿Àïµ÷ÊÔ×Å¿´£¬Å¶£¬ÎÒÓõÄTight VNC viewer ·ÃÎÊlinuxµÄ¡£ºÃÏñûÓÐÖÐÎÄÊäÈëŶ%>_<%


linuxµÄÏÔʾ×Ö·û¼¯ÎÊÌâ°É,Õ³ÌùÉÏÈ¥ÖÐÎľÍÂÒÂ룬»¹Êǵ÷ÕûϰÉ
Äã±¾À´½øÈëµÄ¾ÍÊÇÂÒÂ룬Ä㻹À´ÎÊ£¬ÀË·Ñ´ó¼Ò¸ÐÇé

ÒýÓÃ
linuxµÄÏÔʾ×Ö·û¼¯ÎÊÌâ°É,Õ³ÌùÉÏÈ¥ÖÐÎľÍÂÒÂ룬»¹Êǵ÷ÕûϰÉ
Äã±¾À´½øÈëµÄ¾ÍÊÇÂÒÂ룬Ä㻹À´ÎÊ£¬ÀË·Ñ´ó¼Ò¸ÐÇé

µ«ÊÇÎÒ˵µÄÊÇ£¬ÔÚÏîĿϵ÷ÊԿɲ»ÊÇÂÒÂëŶ

°Ñwindows¿Í»§¶Ë×¢²á±íÀïµÄ×Ö·û¼¯ºÍÊý¾Ý¿âµÄ×Ö·û¼¯Í³Ò»Ï¾ÍÐÐÁË¡£
windowsÏ ½ø×¢²á±í Regedit, ËÑË÷ nls_lang ÐÞ¸ÄΪÊý¾Ý¿â×Ö·û¼¯¡£


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

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 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ