Çë½ÌoracleÎļþµÄÎÊÌâ
Çë½Ì¸÷λ´óÏÀÁ½¸öÎÊÌâ:
£¨1£©ÇëÎÊoracleÊÇ·ñÓо«¼ò°æÏÂÔØ£¿ÍêÕû°æ»ú×ÓʵÔÚÊÇÅܲ»¶¯£¬
¶øÇÒһЩ¹¦ÄÜÒ²Óò»ÉÏ£¬²»ÖªµÀÊÇ·ñÓо«¼ò°æ¡£
£¨2£©ÓÃoracle½øÐпª·¢ÐèÒª°²×°¿Í»§¶ËÂð£¿
лл£¡
º¹£¬Ã»ÈË
1.¾«¼ò°æÒ»Ëµ,ûÌý˵¹ý.
2.Òª°²×°client ¶Ë°æ±¾ oracle.Ò»°ã¿ª·¢»¹Ðè°²×°plsql»òtoad
ÂÌÉ«°æ£¿
ÓÐÒ»¸öoracle xe °æ±¾(Oracle Database 10g Express Edition (XE))
Ã²ËÆ·ûºÏÄãµÄÒªÇó
¸Ðл´ó¼Ò
Ïà¹ØÎÊ´ð£º
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......