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£¬×Ö·û¼¯ÂÒÂëÎÊÌâµÃµ½½â¾ö,ÏÔʾÕýÈ·µÄ¼òÌåÖÐÎÄ×Ö·û¼¯¡£
Ïà¹ØÎĵµ£º
¿ª·¢»·¾³£º
windows2003£¬°²×°ÁËvs2008¡¢SQL Server2005£¬ÕâÊÇ»ù´¡£¨µ±È»ÓÃvs2003£¬vs2005£¬SQL Server2000ɶµÄÒ²¿ÉÒÔ£¬²»¹ýеÄ×ÜÊǹ¦ÄÜÇ¿´óЩô£¬ºÇºÇ£©£»
ÒòΪ¿ª·¢Ê±¾ø´ó²¿·Öʱ¼äÊÇÔÚÄ£ÄâÆ÷Éϵ÷ÊÔ£¬¶ø²»ÊÇPPC£¬ËùÒÔÄ£ÄâÆ÷ÊDZØÐë°²×°µÄ¡£Õë¶ÔÄãµÄPPC²Ù×÷ϵͳѡÔñ¶ÔÓ¦µÄÄ£ÄâÆ÷Óësdk°ü£¬ÎÒ°²×°µÄÊÇWM6ÖÐÎÄ°æµÄ¡££¨windows ......
1433¶Ë¿ÚÓ³Éä ¼ÜÉèsql server
¡¾×ª¡¿ http://blog.csdn.net/lee576/archive/2007/11/12/1880001.aspx
¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ ......
¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ÷Éϵķ½·¨£¬ÏÖÒѽâ¾öÁË£¬ÏàÐÅÒ²Óв»ÉÙÏóÎÒÕâÑùµÄºüÓÑÃÇ¡£¹Ê´Ë£¬ÏÖÔÚ°ÑÎÒʵÏֵķ½·¨Ä ......
1¡¢ ÓóÌÐòÖУ¬±£Ö¤ÔÚʵÏÖ¹¦ÄܵĻù´¡ÉÏ£¬¾¡Á¿¼õÉÙ¶ÔÊý¾Ý¿âµÄ·ÃÎÊ´ÎÊý£»Í¨¹ýËÑË÷²ÎÊý£¬¾¡Á¿¼õÉÙ¶Ô±íµÄ·ÃÎÊÐÐÊý,×îС»¯½á¹û¼¯£¬´Ó¶ø¼õÇáÍøÂ縺µ££»Äܹ»·Ö¿ªµÄ ²Ù×÷¾¡Á¿·Ö¿ª´¦Àí£¬Ìá¸ßÿ´ÎµÄÏìÓ¦Ëٶȣ»ÔÚÊý¾Ý´°¿ÚʹÓÃSQLʱ£¬¾¡Á¿°ÑʹÓõÄË÷Òý·ÅÔÚÑ¡ÔñµÄÊ×ÁУ»Ëã·¨µÄ½á¹¹¾¡Á¿¼òµ¥£»ÔÚ²éѯʱ£¬²»Òª¹ý¶àµØʹÓÃͨÅä·û ÈçSELE ......
ʹÓÃPowerDesignerÉú³ÉÊý¾Ý¿â
½¨±íSQL
½Å
±¾Ê±£¬ÓÈÆäÊÇOracleÊý¾Ý¿âʱ£¬±íÃûÒ»°ã»á´øÒýºÅ¡£Æäʵ¼ÓÒýºÅÊÇPL/SQLµÄ¹æ·¶£¬Êý¾Ý¿â»áÑϸñ°´ÕÕ“”ÖеÄÃû³Æ½¨±í£¬Èç¹ûûÓГ”£¬»á°´ÕÕ
ORACLEĬÈϵÄÉèÖý¨±í£¨DBA
STUDIOÀïÃ棩£¬Ä¬ÈÏÊÇÈ«²¿´óд£¬ÕâÑù£¬ÔÚORACLEÊý¾Ý¿âÀïµÄ×ֶξÍÈç“Column_1&rdqu ......