[OracleÏÂÔØµØÖ·]
Âé·³´ó¼ÒÁË
ÎÒÕâ¸öÈËÓ¢Óï²»ºÃ£¬¹Ù·½¸øµÄOracleµÄÏÂÔØµØÖ·¶¼ÊÇÓ¢ÎÄµÄ ÎÒ¿´²»¶®£¬ÎÒÏÖÔڵIJÙ×÷ϵͳÊÇ£ºMircosoft Windows XP Professional °æ±¾ 2002 Service Pack 3
Çë´ó¼Ò¸ø¸öÕâ¸öϵͳÄÜÓõÄOracleÊý¾Ý¿âÏÂÔØµØÖ·£¬±ð¸øÓкöàÏÂÔØÏîµÄ ÎÒ˵ÁË ÎÒÓ¢ÎÄ¿´²»¶®µÄ ллÄãÃÇÁË
¸ø¸öÄܵã»÷ÏÂÔØ Ö±½Óµ¯³öѸÀ×ÏÂÔØ¿òµÄ
°ÝÍÐÁË
--±¿±¿Ð»¹ýÁË
Oracle9i ¹Ù·½ÏÂÔØµØÖ·
http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
¹ÙÍøÉÏ¿ÉÒÔÑ¡Ôñ¹ú¼ÒµÄ£º
http://www.oracle.com/technology/global/cn/software/products/database/index.html
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
ÔÚ´¥·¢Æ÷µÄÓï·¨ÖУ¬create trigger trg¡¡when £¨new.id>3£© ÔÚÅж¨Ìõ¼þÖУ¬newÇ°Ãæ²»¼ÓðºÅ£¬¹â±È½ÏÁ½¸öÊýµÄÒýÓþͿÉÒÔÅжϴóСÁËÂð£¿ÄѵÀ²»ÊÇÓ¦¸Ã±È½ÏÖ¸ÏòµÄÖµÂð£¿
...²»ÊǺÜÃ÷°×Â¥Ö÷µÄÒâ˼
oracle ¹æ¶¨ÔÚ´¥ ......