¹ØÓÚ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£©µÈ¶ÔÏóȨÏÞ£¬¶ø´æ´¢¹ý³Ì¡¢´æ´¢º¯Êýµ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
·½·¨Ò»£º
----------------------------------------------------------------
---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 ......
INSERT /*+APPEND */ INTO employee (empno,ename,sal,deptno)
SELECT empno,ename,sal,deptno from emp
WHERE deptno=20;
µÚ¶þÌõÓï¾äʹÓÃ/*+APPEND */À´±íʾ²ÉÓÃÖ±½Ó×°ÔØ·½Ê½£¬µ±Òª×°ÔØ´óÅúÁ¿Êý¾Ýʱ£¬²ÉÓõڶþÖÖ·½·¨×°ÔØÊý¾ÝµÄËÙ¶ÈÒªÔ¶Ô¶ÓÅÓÚµÚÒ»ÖÖ·½·¨¡£
ʹÓöà±í²åÈëÊý¾Ý
ʹÓÃALL²Ù×÷·ûÖ´Ðжà±í²åÈëʱ£¬ÔÚÿ¸öÌõ¼þ× ......
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£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ ......