¹ØÓÚORACLEÊý¾Ý¿âÖÐȨÏ޺ͽÇÉ«µÄ̽Ë÷
OracleÊý¾Ý¿âÊÇÒ»ÖÖ´óÐ͹ØϵÐ͵ÄÊý¾Ý¿â£¬ÎÒÃÇÖªµÀµ±Ê¹ÓÃÒ»¸öÊý¾Ý¿âʱ£¬½ö½öÄܹ»¿ØÖÆÄÄЩÈË¿ÉÒÔ·ÃÎÊÊý¾Ý¿â£¬ÄÄЩÈ˲»ÄÜ·ÃÎÊÊý¾Ý¿âÊÇÎÞ·¨Âú×ãÊý¾Ý¿â·ÃÎÊ¿ØÖƵġ£DBAÐèҪͨ¹ýÒ»ÖÖ»úÖÆÀ´ÏÞÖÆÓû§¿ÉÒÔ×öʲô£¬²»ÄÜ×öʲô£¬ÕâÔÚOracleÖпÉÒÔͨ¹ýΪÓû§ÉèÖÃȨÏÞÀ´ÊµÏÖ¡£È¨ÏÞ¾ÍÊÇÓû§¿ÉÒÔÖ´ÐÐijÖÖ²Ù×÷µÄȨÀû¡£¶ø½ÇÉ«ÊÇΪÁË·½±ãDBA¹ÜÀíȨÏÞ¶øÒýÈëµÄÒ»¸ö¸ÅÄËüʵ¼ÊÉÏÊÇÒ»¸öÃüÃûµÄȨÏÞ¼¯ºÏ¡£
1 ȨÏÞ
OracleÊý¾Ý¿âÓÐÁ½ÖÖ;¾¶»ñµÃȨÏÞ£¬ËüÃÇ·Ö±ðΪ£º
¢Ù DBAÖ±½ÓÏòÓû§ÊÚÓèȨÏÞ¡£
¢Ú DBA½«È¨ÏÞÊÚÓè½ÇÉ«£¨Ò»¸öÃüÃûµÄ°üº¬¶à¸öȨÏ޵ļ¯ºÏ£©£¬È»ºóÔÙ½«½ÇÉ«ÊÚÓèÒ»¸ö»ò¶à¸öÓû§¡£
ʹÓýÇÉ«Äܹ»¸ü¼Ó·½±ãºÍ¸ßЧµØ¶ÔȨÏÞ½øÐйÜÀí£¬ËùÒÔDBAÓ¦¸ÃÏ°¹ßÓÚʹÓýÇÉ«ÏòÓû§½øÐÐÊÚÓèȨÏÞ£¬¶ø²»ÊÇÖ±½ÓÏòÓû§ÊÚÓèȨÏÞ¡£
OracleÖеÄȨÏÞ¿ÉÒÔ·ÖΪÁ½Àࣺ
•ÏµÍ³È¨ÏÞ
•¶ÔÏóȨÏÞ
1.1 ϵͳȨÏÞ
ϵͳȨÏÞÊÇÔÚÊý¾Ý¿âÖÐÖ´ÐÐijÖÖ²Ù×÷£¬»òÕßÕë¶ÔijһÀàµÄ¶ÔÏóÖ´ÐÐijÖÖ²Ù×÷µÄȨÀû¡£ÀýÈ磬ÔÚÊý¾Ý¿âÖд´½¨±í¿Õ¼äµÄȨÀû£¬»òÕßÔÚÈκÎģʽÖд´½¨±íµÄȨÀû£¬ÕâЩ¶¼ÊôÓÚϵͳȨÏÞ¡£ÔÚOracle9iÖÐÒ»¹²ÌṩÁË60¶àÖÖȨÏÞ¡£
ϵͳȨÏÞµÄȨÀûºÜ´ó£¬Í¨³£Çé¿öÏ£º
¢Ù Ö»ÓÐDBA²ÅÓ¦µ±ÓµÓÐalter databaseϵͳȨÏÞ£¬¸ÃȨÏÞÔÊÐíÓû§¶ÔÊý¾Ý¿âÎïÀí½á¹¹ºÍ¿ÉÓÃÐÔ½øÐÐÐ޸ġ£
¢Ú Ó¦ÓóÌÐò¿ª·¢ÕßÒ»°ãÓ¦¸ÃÓµÓÐCreate Table¡¢Create ViewºÍCreate TypeµÈϵͳȨÏÞ£¬ÓÃÓÚ´´½¨Ö§³ÖÇ°¶ËµÄÊý¾Ý¿âģʽ¶ÔÏó¡£
¢Û ÆÕͨÓû§Ò»°ãÖ»¾ßÓÐCreate SessionϵͳȨÏÞ£¨¿ÉÒÔͨ¹ýConnection½ÇÉ«»ñµÃ£©£¬Ö»ÓÐCreate SessionϵͳȨÏÞµÄÓû§²ÅÄÜÁ¬½Óµ½Êý¾Ý¿â
¢Ü Ö»ÓоßÓÐGrant Any PrivilegeϵͳȨÏÞÓû§£¬»òÕß»ñÈ¡Á˾ßÓÐWith Admin OptionÑ¡ÏîµÄϵͳȨÏÞµÄÓû§£¬²ÅÄܹ»³ÉΪÆäËüÓû§ÊÚÓèȨÏÞ¡£
1.2¶ÔÏóȨÏÞ
¶ÔÏóȨÏÞÊÇÕë¶Ôij¸öÌض¨µÄģʽ¶ÔÏóÖ´ÐвÙ×÷µÄȨÀû¡£Ö»ÄÜÕë¶Ôģʽ¶ÔÏóÀ´ÉèÖú͹ÜÀí¶ÔÏóȨÏÞ¡£
¶ÔÓÚģʽ¶ÔÏó£º±í¡¢ÊÓͼ¡¢ÐòÁС¢´æ´¢¹ý³Ì¡¢´æ´¢º¯Êý¡¢°ü¶¼¿ÉÒÔ¶ÔÏóÉèÖÃȨÏÞ¡£²»Í¬ÀàÐÍģʽ¶ÔÏó¾ßÓв»Í¬µÄ¶ÔÏóȨÏÞ¡£±ÈÈ磬±í¡¢ÊÓͼµÈ¶ÔÏó¾ßÓвéѯ£¨Select£©¡¢Ð޸ģ¨Update£©¡¢É¾³ý£¨Delete£©µÈ¶ÔÏóȨÏÞ£¬¶ø´æ´¢¹ý³Ì¡¢´æ´¢º¯Êýµ
Ïà¹ØÎĵµ£º
1. ¼ì²éOracleµÄ½ø³Ì
$ ps -ef|grep "ora_"|grep -v grep
oracle 5998 1 0 11:15:59 ? 0:01 ora_j000_PPRD10
oracle 2968 1  ......
·½·¨Ò»£º
----------------------------------------------------------------
---Muti-row to line(col2row)
----------------------------------------------------------------
create or replace type str_tab is table of varchar2(20);
/
grant all on str_tab to public;
create public synonym str_tab for ......
oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º
Code
create [or replace] procedure procedure_name
[(argument[{in|out|in out}] type,
argument[{in|out|in out}] type)]&n ......
³ö´¦£ºhttp://hi.baidu.com/vcy168/blog/item/877945d908c3d52611df9ba0.html
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ ......
ѧϰOracleÊÇÒ»¸öÂþ³¤¼è
ÐÁµÄ¹ý³Ì¡£Èç¹ûûÓÐÐËȤ£¬Ö»ÊDZ»ÆÈѧϰ£¬ÄÇôÊǺÜÄÑѧºÃµÄ¡£Ñ§Ï°µ½Ò»¶¨³Ì¶ÈµÄʱºò£¬ÒªÏë½øÒ»²½Ìá¸ß£¬¾Í²»µÃ²»½Ó´¥ºÜ¶àOracleÖ®ÍâµÄ¶«Î÷£¬Èç
Unix£¬ÈçÍøÂç¡¢´æ´¢µÈ¡£Òò´Ë£¬ÒªÕæµÄ¾öÐÄѧºÃOracle£¬¾ÍÒ»¶¨ÒªÓÐÐËȤ¡£ÓÐÁËÐËȤ£¬¾Í»áÒ»ÇбäµÃ¼òµ¥¿ìÀÖÆðÀ´¡£¼òµ¥×ܽáһϣ¬ÄǾÍÊÇ£ºÐËȤ¡¢Ñ§
Ï°¡¢Êµ¼ù¡£ ......