ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîȨÍþµÄרҵ¼¼Êõ±ê×¼ËüÊÇרΪÈÏÖ¤ÄÇЩÄܹ»Âú×ã¶ÔOracleºËÐIJúÆ·µÄ·þÎñÓëÖ§³Ö²¢¾ßÓÐæµÊìµÄ²Ù×÷ÄÜÁ¦Óë¹ã·ºÀíÂÛ֪ʶµÄרҵÈËÊ¿¡£Oracle ÈÏ֤Ŀǰ·ÖΪÈý¸ö²ã´ÎOCA¡¢OCP¡¢OCM¡£¼´Oracle Certified Professi£¨Ö»ÓÐOracle9iÓд˼¶ÈÏÖ¤£©£¬OCP¼´£¬Oracle Certified Professi£¬OCM¼´Oracle Certified Master¡£ÆäÖÐOCP°üÀ¨ÁËÊý¾Ý¿â¹ÜÀí·½ÏòµÄDBA¡¢Êý¾Ý¿â¿ª·¢·½ÏòµÄDEV¼°OracleÓ¦ÓòúÆ··½ÏòµÄApplicationsר¼Ò¡£
2¡¢ÎÊ£ºOracle ÈÏÖ¤¶ÔÎÒ¸öÈ˵ÄÒâÒåºÎÔÚ£¿
´ð£ºÒâÒåÖØ´ó¡£»ñµÃÓëÖ°ÎñÏà¹ØµÄÈÏÖ¤£¬Ö¤Ã÷ÄúÊÇÒ»¸öºÏ¸ñµÄ¼¼ÊõÈËÔ±¡£ ×÷ΪOracle ÈÏ֤ר¼Ò£¬Äú½«¾ßÓжÔÒµ½ç×î¾ßÌôÕ½ÐԵĻúÓö¸üÉîµÄ¶´²ìÁ¦ ²¢»ñÈ¡¸ü¶àµÄÊÕ»ñ ÐÅÏ¢¼¼ÊõÁìÓòÐèÒª´óÁ¿×¨¼Ò£¬Í¬Ê±¹¤×÷¾ºÕùÒ²Òì³£¼¤ÁÒ£¬ ²»ÂÛ¶ÔÓÚÐÂÊÖ»¹ÊÇÓоÑéµÄר¼Ò¶¼ÐèÒªÕÆÎÕÓÃÈ˵¥Î»¸ÐÐËȤµÄ¼¼Êõ¡£ÓÃÈ˵¥Î»Ñ°ÕÒ¸÷ÖÖ·½Ê½À´Çø·ÖÔ±¹¤ºÍDZÔÚÔ±¹¤ÒªÇóÔ±¹¤±ØÐë¾ß±¸ÎªÓÐЧ¹¤×÷ËùÐèµÄ¼áʵµÄ¼¼Êõ»ù´¡¡£
3¡¢ÎÊ£ºÔõÑù²ÅÄÜ»ñµÃOracle ÈÏÖ¤£¿
¡¡´ð£ºÄúÐèÒª°´ÕÕÄúµÄÖ°Òµ·¢Õ¹·½Ïò£¬²Î¼ÓÅàѵ²¢Í¨¹ýÏàÓ¦µÄOracle¹ú¼ÊÈÏÖ¤¡£
4¡¢ÎÊ£ºÎÒÏ뿼Oracle ÈÏÖ¤£¬ÇëÎʿɲ»¿ÉÒÔÖ±½Ó²Î¼Ó¿¼ÊÔ£¿
´ð£º´Ó2002Äê9ÔÂ1ÈÕÆðOracle¹«Ë¾¿ªÊ¼Ö´ÐÐеÄÈÏÖ¤¹æ¶¨£ºÖ±½Ó²Î¼Ó¿¼ÊÔÄú½«²»ÄÜ»ñµÃ Oracle ÈÏÖ¤¡£Ò²¾ÍÊÇ˵£¬ÄúÈç¹ûÏë»ñµÃOracle¾Í±ØÐë²Î¼ÓOracleÊÚȨ½ÌÓýÖÐÐĵÄÅàѵ£¬Õâ¾ÍÒâζ×ÅÖ»ÓвμÓÁËOracleÕý¹æÑϸñÅàѵµÄÈË£¬²ÅÓÐ×ʸñ»ñµÃOracleר¼ÒÈÏÖ¤£¬Õâ¾Í±£Ö¤ÁËOracle ÈÏÖ¤µÄº¬½ðÁ¿£¬Ò²ÊǶÔOracle ÈÏ֤ר¼ÒµÄ±£»¤¡£
5¡¢ÎÊ£ºOracle 9i²úÆ·µÄ¶¨Î»¼°¹¦ÄÜÊÇʲô£¿
¡¡´ð£ºOracle 9iÊý¾Ý¿âÊÇOracle¹«Ë¾ÍƳöµÄ×îÐÂÒ»´úÊý¾Ý¿â£¬ÓëOracle 8iÏà±ÈÔö¼ÓÁËÉÏ°ÙÖÖÐÂÌØÐÔ£¬ÆäÖÐ×îÍ»³öµÄÊǾ¼ÃÐÔ¡¢¸ß¿ÉÉìËõÐԺ͸߿ÉÓÃÐÔÒÔ¼°ÍêÉƵŦÄÜ¡£Oracle 9i²ÉÓÃÁËReal Application Clusters¼¼Êõ£¬ÎªÓû§ÌṩÁËÎÞÏ޵ĿÉÉìËõÐÔºÍ×
Ïà¹ØÎĵµ£º
SQL> conn system/oracle
Connected.
SQL> create table scott.t1(id number primary key,name varchar2(10)); --´´½¨²âÊÔ±í
Table created.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
2 status,deferrable,deferred,validated
3 fro ......
×÷ÕߣºChris Schalk
ÇáËɹ¹½¨Ò»¸ö»ì´îÓ¦ÓóÌÐò£¬ÒÔʹÓà Oracle XML DB ½« Oracle Êý¾ÝÓë Google Maps API ¼¯³É¡£
2007 Äê 8 Ô·¢²¼
ÕýÈçÄúÖªµÀµÄÄÇÑù£¬Ðí¶àÄêÒÔÇ°£¬Oracle ¾ÍÄܹ»´ÓÊý¾Ý¿â¼´Ê±Éú³É XML¡£³ýÁË´Ó Oracle Êý¾Ý¿âÉú³É XML£¬»¹¿ÉÒÔʹÓöàÖÖÓïÑÔ£¨Èç Java Servlets ºÍ JDBC£©½«Éú³ÉµÄÊý¾Ý XML ·¢²¼µ½ Web¡£ ......
OracleµÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û£¬ÕâÑù£¬ÔÚÖ´Ðвéѯʱ£¬¾Í¿ÉÒÔ±ÜÃâ½øÐÐÕâЩºÄʱµÄ²Ù×÷£¬¶ø´Ó¿ìËٵĵõ½½á¹û¡£ÎﻯÊÓͼÓкܶ෽ÃæºÍË÷ÒýºÜÏàËÆ£ºÊ¹ÓÃÎﻯÊÓͼµÄÄ¿µÄÊÇΪÁËÌá¸ß²éѯÐÔÄÜ£»ÎﻯÊÓͼ¶ÔÓ¦ÓÃ͸Ã÷£¬Ôö¼ÓºÍɾ³ýÎﻯÊÓͼ²»»áÓ°ÏìÓ¦ÓóÌÐòÖÐSQLÓï¾äµÄÕýÈ ......
## Oracle Êý¾Ýµ¼Èëµ½ Mysql ##
__________________________________________ ......
Oracleɾ³ýÖظ´¼Ç¼µÄ×îºÃµÄ·½·¨£º
DELETE from EMP E WHERE E.ROWID > (SELECT MIN(y.ROWID)
from EMP y
WHERE y.EMPNO = E.EMPNO )
1¡¢×Ó²éѯÕÒ³öijԱ¹¤×îµÍµÄROWID£¨¿Ï¶¨Ö»ÓÐÒ»¸ö£©£¬ÆäËü´óÓÚÕâÌõ¼Ç¼ROWIDµÄ£¬È«²¿É¾³ý¡£
2¡¢OracleÖÐʹÓÃROWIDɾ³ýÖظ´¼Ç¼×î¿ì,ÒòΪRowid¶ÔÓ¦ÕâÌõ¼Ç¼ÔÚ´ÅÅÌÉϵÄλÖÃ
ÃæÊÔ£º ......