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
¡¾×ª¡¿ http://blog.csdn.net/lee576/archive/2007/11/12/1880001.aspx
¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ ......
¡¡¡¡ÔÚÊý¾Ý¿âµÄ¿ª·¢¹ý³ÌÖУ¬¾³£»áÓöµ½¸´ÔÓµÄÒµÎñÂß¼ºÍ¶ÔÊý¾Ý¿âµÄ²Ù×÷£¬Õâ¸öʱºò¾Í»áÓÃSPÀ´·â×°Êý¾Ý¿â²Ù×÷¡£Èç¹ûÏîÄ¿µÄSP½Ï¶à£¬ÊéдÓÖûÓÐÒ»¶¨µÄ¹æ·¶£¬½«»áÓ°ÏìÒÔºóµÄϵͳά»¤À§ÄѺʹóSPÂß¼µÄÄÑÒÔÀí½â£¬ÁíÍâÈç¹ûÊý¾Ý¿âµÄÊý¾ÝÁ¿´ó»òÕßÏîÄ¿¶ÔSPµÄÐÔÄÜÒªÇóºÜ£¬¾Í»áÓöµ½ÓÅ»¯µÄÎÊÌ⣬·ñÔòËÙ¶ÈÓпÉÄܺÜÂý£¬¾¹ýÇ×Éí¾Ñ飬һ¸ö¾ ......
ÐÔÄܼà¿ØÖ®¼à¿Ø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 ......
SELECT
(case when a.colorder=1 then d.name
--+'('+cast(h.value as nvarchar)+')'
else '' end)±íÃû,
a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
isnull(g.[value],'') AS ×Ö¶Î˵Ã÷,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '¡Ì'else '' end) ±êʶ,
(case whe ......
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 ......