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 Ö÷ÒªÅäÖÃÎļþ½éÉÜ£º
profileÎļþ£¬oratab Îļþ£¬Êý¾Ý¿âʵÀý³õʼ»¯Îļþ initSID.ora£¬¼àÌýÅäÖÃÎļþ£¬ sqlnet.ora Îļþ£¬tnsnames.ora Îļþ
1.2 Oracle Ö÷ÒªÅäÖÃÎļþ½éÉÜ
1.2.1 /etc/profile Îļþ
ϵͳ¼¶µÄ»·¾³±äÁ¿Ò»°ãÔÚ/etc/p ......
oracle ÖÐ TO_DATE º¯ÊýµÄʱ¼ä¸ñʽ£¬ÒÔ 2008-09-10 23:45:56 ΪÀý
¸ñʽ
˵Ã÷
ÏÔʾֵ
±¸×¢
Year(Äê):
yy
two digits(Á½Î»Äê)
08
yyy
three digits(ÈýλÄê)
008
yyyy
four digits(ËÄλÄê)
2008
Month(ÔÂ):
mm
number(Á½Î»ÔÂ)
09
mon
abbre ......
IDÊÇÖ÷½¡£¬ÊµÏÖ²åÈëÒ»¸öNAME,ID×Ô¶¯Ôö¼Ó
SQL> create table t1
2 (
3 id & ......
RedoµÄÄÚÈÝ
Oracleͨ¹ýRedoÀ´ÊµÏÖ¿ìËÙÌá½»£¬Ò»·½ÃæÊÇÒòΪRedo Log File¿ÉÒÔÁ¬Ðø¡¢Ë³ÐòµØ¿ìËÙд³ö£¬ÁíÒ»¸ö·½ÃæÒ²ºÍRedo¼Ç¼µÄ¾«¼òÄÚÈÝÓйء£
Á½¸ö¸ÅÄ
¸Ä±äÏòÁ¿£¨Change Vector£©
¸Ä±äÏòÁ¿±íʾ¶ÔÊý¾Ý¿âÄÚijһ¸öÊý¾Ý¿éËù×öµÄÒ»´Î±ä¸ü¡£¸Ä±äÏòÁ¿Öаüº¬Á˱ä¸üµÄÊý¾Ý¿éµÄ°æ±¾ºÅ¡¢ÊÂÎñ²Ù×÷´úÂë¡¢±ä¸ü´ÓÊôÊý¾Ý¿éµÄµØÖ·£¨DBA£ ......
ÔÚ¿ªÊ¼Ö®Ç°£¬ÎÒÃÇÏÈÀ´Ë¼¿¼¼¸¸öÎÊÌ⣿
1. ora-01555´íÎóµÄÊÇÔõô²úÉúµÄ£¿ÓÐʲô°ì·¨½â¾ö£¿
¸ÃÎÊÌ⣬²Î¿¼ÎÒµÄBlog£º Oracle ORA-01555¿ìÕÕ¹ý¾É
http://blog.csdn.net/tianlesoftware/archive/2009/10/31/4745898.aspx
2. »Ø¹ö¶Î(»Ø¹ö ......