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 ÐÞ¸ÄΪÊý¾Ý¿â×Ö·û¼¯¡£
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£© tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname ½á¹û£º µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......