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

PL/SQL ÖÐÎÄÂÒÂë½â¾ö·½°¸

1. ʹÓõÄÊÇ·þÎñÆ÷Éϵģ¬²»ÊDZ¾»úµÄOracle£¬°´ÏÂÃæ×ö¾Í¿ÉÒÔÁË£º
    ÉèÖû·¾³±äÁ¿:NLS_LANG£¬¾ßÌåÖµÓÃÏÂÃæ²éѯµÄÖµ:
SELECT 'AMERICAN_AMERICA.' || PROPERTY_VALUE
from DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'NLS_CHARACTERSET';
2. Èç¹ûÊDZ¾»úµÄOracle¾ÍÐèÒªÔÚOracleµÄ°²×°Ä¿Â¼ÏÂÃæ¸ÄÉèÖãº
ÓÐÒ»¸öÅäÖÃÎļþÃûΪdbappscfg.properties£¬Ð޸ĸÃÎļþ¼´¿É½â¾öÉÏÊöÎÊÌâ¡£Õâ¸öÎļþµÄλÖÃÔÚ$oracle_home\sysman\configĿ¼Ï£¬ÓÃÈκεÄÎı¾±à¼­Æ÷´ò¿ª¸ÃÎļþ£¬ÔÚÕâ¸öÎļþÀïÃ棬ÕÒµ½ÕâÑùÒ»Ï
# sqlplus_nls_lang=american_america.we8iso8859p1
È¥µô×¢ÊÍ·û#£¬Í¬Ê±½«ÆäÐÞ¸ÄΪsqlplus_nls_lang=american_america.zhs16gbk¡£
¶ÔÓÚwindows²Ù×÷ϵͳ£¬»¹ÐèÒªÐÞ¸ÄÒ»ÏÔÚÎļþÖÐÕÒµ½# sqlplus_systemroot=c:\\winnt40£¬È¥µô×¢ÊÍ·û£¬½«ÆäÐÞ¸ÄΪÄãËùÔÚ»úÆ÷µÄ²Ù×÷ϵͳÖ÷Ŀ¼¡£Èç²Ù×÷ϵͳµÄÖ÷Ŀ¼ÔÚdÅ̵ÄwinntÏ£¬Ôò½«ÆäÐÞ¸ÄΪ sqlplus_systemroot=d:\\winnt¡£
¶ÔÓÚºóÃæÒ»ÏîµÄÐÞ¸ÄÖ»¶Ôwindows²Ù×÷ϵͳ½øÐУ¬¶Ôunix²Ù×÷ϵͳÔò²»ÐèÒª¡£Èç¹ûÔÚwindows²Ù×÷ϵͳÖв»Ð޸ĸÃÏÔÚoracle enterprise managerÖУ¬Á¬½Óϵͳʱ£¬»áÌáʾÈçϵĴíÎó£º
ora-12560 tns:protocol adapter error
»òÕß
ora-12545 connect failed because target host or object does not exist
ÐÞ¸ÄÍê³Éºó£¬±£´æÎļþ£¬Í˳ö±à¼­¡£ÖØÐÂÁ¬½Ósql plus worksheet£¬×Ö·û¼¯ÂÒÂëÎÊÌâµÃµ½½â¾ö,ÏÔʾÕýÈ·µÄ¼òÌåÖÐÎÄ×Ö·û¼¯¡£


Ïà¹ØÎĵµ£º

1433¶Ë¿ÚÓ³Éä ¼ÜÉèsql server

¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
      ½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ÷Éϵķ½·¨£¬ÏÖÒѽâ¾öÁË£¬ÏàÐÅÒ²Óв»ÉÙÏóÎÒÕâÑùµÄºüÓÑÃÇ¡£¹Ê´Ë£¬ÏÖÔÚ°ÑÎÒʵÏֵķ½·¨Ä ......

asp.net ÖÆ×÷°²×°°ü²¢×Ô¶¯°²×°SQLÊý¾Ý¿â

Ò»).´´½¨²¿ÊðÏîÄ¿    
  1.   ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£    
  2.   ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеē°²×°ºÍ²¿ÊðÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñ ......

ÐÔÄܼà¿ØÖ®¼à¿ØSQLÓï¾ä

ÐÔÄܼà¿ØÖ®¼à¿ØSQLÓï¾ä 
·ÖÎö±í 
analyze table tablename compute statistics for all indexes; 
analyze table tablename compute statistics for all indexed columns; 
analyze table tablename compute statistics for table; 
¼à¿ØÊÂÀýµÄµÈ´ý 
select event,sum(decode(wait_Tim ......

SQLÓï¾äÓÅ»¯

SQLÓï¾äµÄÓÅ»¯¾ÍÊǽ«ÐÔÄܽϵ͵ÄSQLÓï¾äת»»´ï³ÉͬÑùÄ¿µÄÐÔÄÜÓÅÒìµÄSQLÓï¾ä
ÏÂÃæÎÒÃÇÒ»ÆðÀ´¿´¿´Ò»Ð©¿ÉÒÔÓÅ»¯SQLµÄ·½·¨£¬Ï£Íû´ó¼Ò¶àÌá³öÒâ¼ûÎÒÃǹ²Í¬Ñ§Ï°»òÕßÊÇ´ó¼ÒÓÐʲôºÃµÄÓÅ»¯·½·¨¿ÉÒÔÌá³öÀ´¹²Ïíһϡ£
 
µÚÒ»ÖÖÓÅ»¯£¨Ê¹ÓÃÖ¸¶¨ÁдúÌæ”*”£©
       ʹÓÓ*&rdquo ......

SQL Server ¹ÜÀí³£ÓõÄSQLºÍT SQL

1. ²é¿´Êý¾Ý¿âµÄ°æ±¾  
  select @@version
 
  ³£¼ûµÄ¼¸ÖÖSQL SERVER´ò²¹¶¡ºóµÄ°æ±¾ºÅ:
 
  8.00.194   Microsoft SQL Server 2000
  8.00.384   Microsoft SQL Server 2000 SP1
  8.00.532   Microsoft SQL Server 2000 SP2
  8.00.760 &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ