Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

[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


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......

OracleÖа󶨱äÁ¿µÄÎÊÌâ

ÔÚ´¥·¢Æ÷µÄÓï·¨ÖУ¬create trigger trg¡­¡­when £¨new.id>3£© ÔÚÅж¨Ìõ¼þÖУ¬newÇ°Ãæ²»¼ÓðºÅ£¬¹â±È½ÏÁ½¸öÊýµÄÒýÓþͿÉÒÔÅжϴóСÁËÂð£¿ÄѵÀ²»ÊÇÓ¦¸Ã±È½ÏÖ¸ÏòµÄÖµÂð£¿
...²»ÊǺÜÃ÷°×Â¥Ö÷µÄÒâ˼
oracle ¹æ¶¨ÔÚ´¥ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ