ÈçºÎ»ñµÃOracle OCPÈÏÖ¤ÒÔ¼°OCPÈÏÖ¤µÄÓÅÊÆ
OracleÈÏ֤ר¼Ò——OCP£¬ÊÇÓÉOracle¹«Ë¾ÊÚȨ¹ú¼Ê¿¼ÊÔÈÏÖ¤ÖÐÐĶԿ¼Éú½øÐеÄ×ʸñÈÏÖ¤¡£¿¼Éú°´¿¼ÊÔ±ê×¼ÒªÇó²Î¼Ó¼¸Ãſγ̵Ŀ¼ÊÔ(Ò»°ãΪ3—5ÃÅ)£¬ÔÚͨ¹ýÈ«²¿¿¼ÊԺ󣬱ã¿É»ñµÃOCPµÄר¼ÒÈÏÖ¤¡£
ĿǰOCPÈÏÖ¤¿¼ÊÔ·ÖΪ£º
Database AdministratorDatabase OperatoDatabase DeveloperJava DeveloperApplication ConsultantÆäÖУ¬Oracle DBAÊÇ×î³ÔÏ㣬µ«Ò²ÊÇ×îÄÑ¿¼µÄÒ»¸öÈÏÖ¤¡£
OCPÈÏÖ¤µÄËùÓп¼ÊÔÒ²ÊÇͨ¹ýPrometric¹«Ë¾×éÖ¯µÄ£¬ÔÚPrometricÊÚȨ¿¼ÊÔÖÐÐÄ¿ÉÒÔ±¨Ãû²Î¼ÓOCPÈÏÖ¤¿¼ÊÔ¡£Ä¿Ç°OCPÿÃÅ¿¼ÊԵķÑÓÃΪ125ÃÀÔª¡£
×ܵÄÀ´Ëµ£¬ITÒµ¶Ôר¼ÒµÄÒªÇóºÜ¸ß£¬Ö°Òµ¾ºÕùѹÁ¦ºÜ´ó¡£ÎÞÂÛÊÇнøÈëÕâ¸öÐÐÒµµÄÈË£¬»¹ÊÇ´ËÐÐÒµÖеÄÀÏÊÖ£¬¶¼ÐèÒªÖªµÀËûÃǵÄÄÇЩ¼¼Êõ±³¾°ÄÜÕæÕýÎüÒýµ½¹ÍÖ÷µÄÑ۹⡣ͬʱ£¬¹ÍÖ÷ÃÇÒ²ÐèÒªÒ»¸ö±ê×¼°ïÖúËûÃÇÌôÑ¡³öÄÇЩ¼¼ÊõÉÏÕæÕý¹ýÓ²µÄ¹ÍÔ±¡£OCPÈÏÖ¤¾ÍÄܹ»°ïÖúITÒµ½ç½¨Á¢ÆðÃæÏòÌØ¶¨Ö°Î»µÄÑ¡Ôñ±ê×¼¡£OCPÈÏÖ¤ÊÇÒ»¸öÓмÛÖµµÄ¡¢Òµ½ç³ÐÈϵıê×¼£¬Õâ¸ö±ê×¼¿ÉÒÔÖ¤Ã÷³ÖÖ¤ÕßµÄ֪ʶºÍÄÜÁ¦Ë®Æ½¡£
OCPÈÏÖ¤¿ÉÒÔ¸øÄãÒ»¸öÏÊÃ÷µÄÓÅÊÆ¡£OCPÈÏÖ¤¿ÉÒÔ±íÃ÷Äã¶Ôijһְλ¼°Ïà¹ØµÄOracle²úÆ·ÓÐ×ÅÉî¿ÌµÄÀí½â¡£³ÉΪһ¸öOCPÈÏ֤ר¼Ò¿ÉÒÔ°ïÖúÄã±»¸ü¶àµÄ¹ÍÖ÷×¢Òâµ½£¬²¢ÇÒÔö¼ÓÄã»ñµÃITÒµ×î¾ßÌôÕ½ÐÔ»úÓöµÄ»ú»á¡£OCPÈÏ֤ר¼ÒÃÇ֤ʵÁËOCPÈÏÖ¤µÄ¼ÛÖµ£º97%µÄ OCPÈÏΪËûÃÇ»ñÒæÓÚOCPÈÏÖ¤;89%µÄOCPÈÏΪ»ñµÃÈÏÖ¤ºó£¬ËûÃÇÔÚOracleר¼ÒµÄְλÉϸü¾ßÐÅÐÄ;
OCPÈÏ֤ͬʱ¿ÉÒÔ°ïÖúITÒµµÄÈËʾÀíÔÚӦƸÕßÖÐÌôÑ¡³ö·ûºÏÌôÕ½ÐÔְλµÄÔ±¹¤¡£¶ÔÓÚÄÇЩÿÄê°ÑÔ±¹¤ËÍÈ¥ÅàѵµÄ¹«Ë¾£¬ÈÏÖ¤¿ÉÒÔ±£Ö¤ËûÃÇÔÚÅàѵÉϵÄǮûÓа׻¨——ËûÃǵÄÔ±¹¤»ñµÃÁ˶ÔÓÚÉîÈëÀí½âºÍ±ØÒªµÄ֪ʶ¡£¹«Ë¾Ò²¿ÉÒÔ°ÑÈÏÖ¤ºÍÔ±¹¤µÄÖ°Òµ·¢Õ¹ÁªºÏÆðÀ´£¬ÕâÑù¿ÉÒÔÔöǿԱ¹¤µÄÖҳ϶ȼ°ËûÃÇÔÚÖ°Òµ¸ÚλÉϵıíÏÖ¡£Í¬Ê±£¬¹ÍÓûñµÃÈÏÖ¤µÄר¼Ò¿ÉÒÔÖ±½ÓÌá¸ß¹«Ë¾µÄʵÁ¦£¬¹ú¼ÊÊý¾Ý¹«Ë¾(International Data Corporation)µÄÒ»ÏîÑо¿ÏÔʾÁËÕâÒ»µã¡£
¶«·½ÈðͨITÅàѵÓë·þÎñÖÐÐÄÓµÓÐÊ®ÄêITÅàѵ¾Ñ飬רעÖйú¸ß¶ËITÅàѵÊÇÖйú¸ß¶ËITÅàѵµÚÒ»Æ·ÅÆ£¬¶«·½ÈðͨITÅàѵÓë·þÎñÖÐÐÄΪITÅàѵ»ú¹¹¼°¹ã´óѧԱÌá¹©È«Ãæ¡¢Ï¸Ö¡¢×¨ÒµµÄÏßÉÏ¡¢ÏßÏ·þÎñ£¬ÖÂÁ¦ÓÚΪ¿Í»§ÌáÉýÁ¼ºÃµÄÖ°Òµ¾ºÕùÁ¦£¬http://www.easthome.com/
Ïà¹ØÎĵµ£º
´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, ÌØ±ð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ¡£
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡ ......
in/not inÔÚÅжÏNULLʱÓõÄÓë=/<>Ò»ÑùµÄ·½Ê½£¬¼´±ØÐëÓÃis nullÀ´Åжϣ¬·ñÔòʼÖÕΪʧ°Ü¡£
Óï¾ä
select 'true' from dual where (1,2) not in ((2,3),(2,null));
³É¹¦µÄÔÒòÔÚÓÚÅж϶þÔªÖµÊ±Ê ......
°´±í·½Ê½µÄµ¼³ö£¬µ¼Èë
exp SYSTEM/SYSTEM@SBJSDB00 TABLES=KOKAN90.MASTER_SEND_LIMIT LOG=C:\A.LOG
IMP SYSTEM/SYSTEM@SBJSDB00 IGNORE=Y FULL=Y LOG=C:\B.LOG
֮ǰÓùýºÜ¶àÓï¾ä¶¼±¨´í£¬µÃµ½µÄ½ÌѵÊÇ ÏÈÖ´ÐÐexp SYSTEM/SYSTEM@SBJSDB00£¬°´Ìáʾһ²½²½ÊäÈë³É¹¦¹ýºó£¬ÔÙ°ÑÌáʾ·Òë³É²ÎÊýºÍ²ÎÊýÖµ
¹ØÓÚ²ÎÊý˵Ã÷Óà exp hel ......
oracle Óαê
¹Ø¼ü×Ö: oracle Óαê
1. Óαê: ÈÝÆ÷£¬´æ´¢SQLÓï¾äÓ°ÏìÐÐÊý¡£
2. ÓαêÀàÐÍ: ÒþʽÓα꣬ÏÔʾÓα꣬REFÓαꡣÆäÖУ¬ÒþʽÓαêºÍÏÔʾÓαêÊôÓÚ¾²Ì¬Óα꣨ÔËÐÐǰ½«ÓαêÓëSQLÓï¾ä¹ØÁª£©,REFÓαêÊôÓÚ¶¯Ì¬Óαê(ÔËÐÐʱ½«ÓαêÓëSQLÓï¾ä¹ØÁª)¡ ......
Óαê
Ö¸ÏòÉÏÏÂÎÄÇøÓòµÄ¾ä±ú»òÖ¸Õë
ÓαêÔÚ·þÎñÆ÷¶Î´æ´¢
ÊôÐÔ
%NOTFOUND ûÓÐÕÒµ½½á¹û»òûÓвÙ×÷³É¹¦
%FOUND ÕÒµ½½á¹û»ò²Ù×÷³É¹¦
%ROWCOUNT ÓαêÓ°ÏìµÄÐÐÊý
%ISOPEN ÓαêÊÇ·ñ´ò¿ª Ò ......