PL/SQL DEVELOPERÓëORACLE SQLDEVELOPERÄĸö¸üºÃÓã¿
´ó¶àÊýÈ˶¼ÍƼöPL/SQL DEVELOPER£¬µ«ÊÇÒ²ÓеÄ˵ORACLE SQLDEVELOPERÓÃ×Å˳ÊÖ
ËûÃǹ¦ÄÜÉÏÓÐÊ²Ã´Çø±ðÂð£¿
ºÇºÇºÇ£¬Ã¿個ÈË對¹¤¾ßµÄÁ˽â³Ì¶È²»Í¬£¬對¹¤¾ßµÄϲºÃÒ²會Óвî異¡£
ÎÒ兩種¹¤¾ß¶¼ÓÃ過£¬´óÖÂÉϹ¦Äܶ¼ÊÇÒ»樣µÄ£¬ÎÒ¾Í談談²î異°É
plsql還ÊDZÈ較Ö÷Á÷µÄ£¬ÔÚ開發ºÍ¹ÜÀíÉ϶¼±È較·½±ã£¬還Ö§³Ö導Èë¡£導³ö¹¦ÄÜ£¬ ²»過ÐèÒª°²裝OracleµÄ¿Í戶¶Ë£¬²¢ÇÒÐèÒªÅäÖÃtnsname¡£這ÊÇÎÒ覺µÃ£¬ËûÉÔ΢Èõ勢µÄÒ»點¡£
Oracle psql devÄØ£¬ÊÇOracle×Ô帶µÄ¹¤¾ß£¬11gÒÑ經內Ƕµ½數據庫µÄ°²裝ÀïÈ¥ÁË£¬Ò²Ìṩ±È較ºÃµÄ開發ºÍ¹ÜÀíµÄ¹¦ÄÜ£¬µ«ÊÇÏà對plsql來說£¬ÒªÈõһЩ£¬²»過ÆäÖÐ帶ÓеÄmigration toolsÊÇÎÒ鐘ÇéÓڴ˹¤¾ßµÄÒ»點¡£ ¿ÉÒÔ對異構»òÕßͬ構µÄ數據庫進ÐÐ數據遷ÒÆ£¬ÎÒÔÚmysqlºÍms sqlÉ϶¼×ö個²»ÊǺÜ復雜µÄ遷ÒÆ£¬還ÊǺܷ½±ãºÍ實Óõ쬶øÇÒ該¹¤¾ß×îºÃµÄÒ»點ÊÇ java開發£¬Ê¹ÓõÄjdbcµÄ連½Ó·½Ê½£¬ËùÒÔ¼´Ê¹沒Óа²裝¿Í戶¶ËÒ²¿ÉÒÔͨ過thinµÄ·½Ê½連½Ó
這兩個¹¤¾ßÔÚ開發ºÍ¹ÜÀíÉÏ plsql dev 勝³öÒ»籌
µ«ÊÇÔÚ遷ÒÆ¹¦ÄÜºÍ¿çÆ½臺ÉÏ sql devÓÖÁÁ點¶à¶à¡£
Äã¸ù據Äã×Ô¼ºµÄÇé況來進ÐÐ選
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......