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

¹ØÓÚ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£©µÈ¶ÔÏóȨÏÞ£¬¶ø´æ´¢¹ý³Ì¡¢´æ´¢º¯Êýµ


Ïà¹ØÎĵµ£º

linuxÖÐoracleµÄÈÕ³£Î¬»¤ÃüÁî

1.  ¼ì²éOracleµÄ½ø³Ì
$  ps -ef|grep "ora_"|grep -v grep
  oracle  5998     1  0 11:15:59 ?        0:01 ora_j000_PPRD10
  oracle  2968     1  ......

oracleÁÐתÐз½·¨×ܽá

·½·¨Ò»£º
----------------------------------------------------------------
---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 ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç

oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º     
Code
create [or replace] procedure procedure_name
  [(argument[{in|out|in out}] type,
    
   argument[{in|out|in out}] type)]&n ......

WindowsXPÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â

 ³ö´¦£ºhttp://hi.baidu.com/vcy168/blog/item/877945d908c3d52611df9ba0.html
WindowsÏÂORACLE 10g°²×°Óë²Ù×÷ͼ½â
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ ......

¶ÔOracleѧϰÕßµÄһЩ½¨Òé

ѧϰOracleÊÇÒ»¸öÂþ³¤¼è
ÐÁµÄ¹ý³Ì¡£Èç¹ûûÓÐÐËȤ£¬Ö»ÊDZ»ÆÈѧϰ£¬ÄÇôÊǺÜÄÑѧºÃµÄ¡£Ñ§Ï°µ½Ò»¶¨³Ì¶ÈµÄʱºò£¬ÒªÏë½øÒ»²½Ìá¸ß£¬¾Í²»µÃ²»½Ó´¥ºÜ¶àOracleÖ®ÍâµÄ¶«Î÷£¬Èç
Unix£¬ÈçÍøÂç¡¢´æ´¢µÈ¡£Òò´Ë£¬ÒªÕæµÄ¾öÐÄѧºÃOracle£¬¾ÍÒ»¶¨ÒªÓÐÐËȤ¡£ÓÐÁËÐËȤ£¬¾Í»áÒ»ÇбäµÃ¼òµ¥¿ìÀÖÆðÀ´¡£¼òµ¥×ܽáһϣ¬ÄǾÍÊÇ£ºÐËȤ¡¢Ñ§
Ï°¡¢Êµ¼ù¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ