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

ORACLEÊÓͼ


2008Äê06ÔÂ01ÈÕ ÐÇÆÚÈÕ 14:52
OracleµÄÊý¾Ý¿â¶ÔÏó·ÖΪÎåÖÖ£º±í£¬ÊÓͼ£¬ÐòÁУ¬Ë÷ÒýºÍͬÒå´Ê¡£ 
ÊÓͼÊÇ»ùÓÚÒ»¸ö±í»ò¶à¸ö±í»òÊÓͼµÄÂß¼­±í£¬±¾Éí²»°üº¬Êý¾Ý£¬Í¨¹ýËü¿ÉÒÔ¶Ô±íÀïÃæµÄÊý¾Ý½øÐвéѯºÍÐ޸ġ£ÊÓͼ»ùÓÚµÄ±í³ÆÎª»ù±í¡£ 
ÊÓͼÊÇ´æ´¢ÔÚÊý¾Ý×ÖµäÀïµÄÒ»ÌõselectÓï¾ä¡£ ͨ¹ý´´½¨ÊÓͼ¿ÉÒÔÌáÈ¡Êý¾ÝµÄÂß¼­Éϵļ¯ºÏ»ò×éºÏ¡£ 
ÊÓͼµÄÓŵ㣺 
1.¶ÔÊý¾Ý¿âµÄ·ÃÎÊ£¬ÒòΪÊÓͼ¿ÉÒÔÓÐÑ¡ÔñÐÔµÄѡȡÊý¾Ý¿âÀïµÄÒ»²¿·Ö¡£ 
2.Óû§Í¨¹ý¼òµ¥µÄ²éѯ¿ÉÒÔ´Ó¸´ÔÓ²éѯÖеõ½½á¹û¡£ 
3.ά»¤Êý¾ÝµÄ¶ÀÁ¢ÐÔ£¬ÊÔͼ¿É´Ó¶à¸ö±í¼ìË÷Êý¾Ý¡£ 
4.¶ÔÓÚÏàͬµÄÊý¾Ý¿É²úÉú²»Í¬µÄÊÓͼ¡£ 
ÊÓͼ·ÖΪ¼òµ¥ÊÓͼºÍ¸´ÔÓÊÓͼ£º 
¼òµ¥ÊÓͼֻ´Óµ¥±íÀï»ñÈ¡Êý¾Ý 
¸´ÔÓÊÓͼ´Ó¶à±í 
¼òµ¥ÊÓͼ²»°üº¬º¯ÊýºÍÊý¾Ý×é 
¸´ÔÓÊÓͼ°üº¬ 
¼òµ¥ÊÓͼ¿ÉÒÔʵÏÖDML²Ù×÷ 
¸´ÔÓÊÓͼ²»¿ÉÒÔ. 
ÊÓͼµÄ´´½¨£º 
CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view_name 
[(alias[, alias]...)] 
AS subquery 
[WITH CHECK OPTION [CONSTRAINT constraint]] 
[WITH READ ONLY] 
ÆäÖУº 
OR REPLACE £ºÈôËù´´½¨µÄÊÔͼÒѾ­´æÔÚ£¬ORACLE×Ô¶¯Öؽ¨¸ÃÊÓͼ£» 
FORCE £º²»¹Ü»ù±íÊÇ·ñ´æÔÚORACLE¶¼»á×Ô¶¯´´½¨¸ÃÊÓͼ£» 
NOFORCE £ºÖ»Óлù±í¶¼´æÔÚORACLE²Å»á´´½¨¸ÃÊÓͼ£º 
alias £ºÎªÊÓͼ²úÉúµÄÁж¨ÒåµÄ±ðÃû£» 
subquery £ºÒ»ÌõÍêÕûµÄSELECTÓï¾ä£¬¿ÉÒÔÔÚ¸ÃÓï¾äÖж¨Òå±ðÃû£» 
WITH CHECK OPTION £º 
²åÈë»òÐ޸ĵÄÊý¾ÝÐбØÐëÂú×ãÊÓͼ¶¨ÒåµÄÔ¼Êø£» 
WITH READ ONLY £º 
¸ÃÊÓͼÉϲ»ÄܽøÐÐÈκÎDML²Ù×÷¡£ 
ÀýÈ磺 
CREATE OR REPLACE VIEW dept_sum_vw 
(name,minsal,maxsal,avgsal) 
AS SELECT d.dname,min(e.sal),max(e.sal),avg(e.sal) 
from emp e,dept d 
WHERE e.deptno=d.deptno 
GROUP BY d.dname; 
ÊÓͼµÄ¶¨ÒåÔ­Ôò£º 
1.ÊÓͼµÄ²éѯ¿ÉÒÔʹÓø´ÔÓµÄSELECTÓï·¨£¬°üÀ¨Á¬½Ó/·Ö×é²éѯºÍ×Ó²éѯ£» 
2.ÔÚûÓÐWITH CHECK OPTIONºÍ READ ONLY µÄÇé¿öÏ£¬²éѯÖв»ÄÜʹÓà
ORDER BY ×Ӿ䣻 
3.Èç¹ûûÓÐΪCHECK OPTIONÔ¼ÊøÃüÃû£¬ÏµÍ³»á×Ô¶¯ÎªÖ®ÃüÃû£¬ÐÎʽΪSYS_Cn; 
4.OR REPLACEÑ¡Ïî¿ÉÒÔ²»É¾³ýÔ­ÊÓͼ±ã¿É¸ü¸ÄÆä¶¨Òå²¢ÖØ½¨£¬»òÖØÐÂÊÚÓè¶ÔÏó 
ȨÏÞ¡£ 
ÊÓͼµÄ²éѯ£º 


Ïà¹ØÎĵµ£º

Oracle ²éѯ¡¢¸üлù±¾²Ù×÷

oracle ĬÈϸôÀëµÈ¼¶ÊÇ£º¶ÁÒÑÌá½»¡£
²éÑ¯Ëø¶¨£¬·ÀÖ¹ÁíÍâÓû§¸üУº
select * from books for update;
µ±Ç°Óû§¸üÐÂÖ®ºó£¬ÁíÍâÓû§¿ÉÒÔ¸ü¸Ä¡£
01¡¢±íÁ¬½Ó
¼Ù¶¨from×Ó¾äÖдÓ×óµ½ÓÒÁ½¸ö±í·Ö±ðΪA£¬B±í¡£
ÄÚÁ¬½Ó£ºÑ¡È¡A¡¢B±íµÄÍêȫƥÅäµÄ¼¯ºÏ£¬Á½±í½»¼¯£º
select empno,ename,emp.deptno A,dept.deptno B,dname from emp ......

Oracle°²È«È«½Ó´¥£¨ÉÏ£©

Ëæ×żÆËã»úµÄÆÕ¼°ÒÔ¼°ÍøÂçµÄ·¢Õ¹£¬Êý¾Ý¿âÒѾ­²»ÔÙ½ö½öÊÇÄÇЩ³ÌÐòÔ±ËùרÓеϰÌâ¡£¶øOracleÊý¾Ý¿â¸üÊÇÆ¾½èÆäÐÔÄÜ׿Խ£¬²Ù×÷·½±ãÁé»îµÄÌØµã£¬ÔÚÊý¾Ý¿âµÄÊг¡ÖÐÒѾ­Õ¼¾ÝÁËһϯ֮µØ¡£µ«ÊÇͬÑùËæ×ÅÍøÂç¼¼ÊõµÄ²»¶Ï½ø²½£¬Êý¾ÝÐÅÏ¢µÄ²»¶ÏÔö¼Ó£¬Êý¾Ý°²È«ÒѾ­²»ÔÙÊÇÒÔǰµÄ“ÀÏÉú³¤Ì¸”£¬Ò²¸ü²»ÊÇÒÔǰÊé±¾ÉÏÄÇЩ“¿ÉÍû² ......

ѧºÃOracleÁùÌõ×ܽá

 
1¡¢Èç¹ûÓÐÒ»¶¨µÄÊý¾Ý¿â»ù´¡£¬ÖªµÀSQLÊÇÔõô»ØÊ£¬¼´Ê¹Ð´²»³öÀ´¼òµ¥µÄSQL£¬µ«¿ÉÒÔ¿´¶¯ËüÃÇ£¬Äã¾Í¿ÉÒÔÌøµ½2¡£·ñÔòÇëÏÈ¿´Ò»ÏÂÊý¾Ý¿â»ù´¡ºÍSQLÓïÑÔ£¬²»ÐèÒªºÜÉ¸ü²»ÐèҪȥ¼ÇÒäÄÇЩ¸´ÔÓµÄSQLÃüÁÕâЩ¿ÉÒÔÁôÔÚÒÔºó±ßÓ¦Óñßѧϰ¡¢¼ÇÒä¡£
¡¡¡¡
¡¡¡¡2¡¢ÒªÏëѧºÃORACLE£¬Ê×ÏÈҪѧϰORACLEµÄÌåϵ½á¹¹£¬ÏÖÔÚÄã²»ÐèÒªÉîÈëÀ ......

oracleÖÐʵÏÖÖ÷¼ü×Ô¶¯Éú³É

 IDÊÇÖ÷½¡£¬ÊµÏÖ²åÈëÒ»¸öNAME,ID×Ô¶¯Ôö¼Ó
SQL>   create   table   t1  
      2     (  
      3         id    & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ