Oracle ÊÓͼ
ÊÓͼ(view)£¬Ò²³ÆÐé±í, ²»Õ¼ÓÃÎïÀí¿Õ¼ä£¬Õâ¸öÒ²ÊÇÏà¶Ô¸ÅÄÒòΪÊÓͼ±¾ÉíµÄ¶¨ÒåÓï¾ä»¹ÊÇÒª´æ´¢ÔÚÊý¾Ý×ÖµäÀïµÄ¡£ÊÓͼֻÓÐÂß¼¶¨Ò塣ÿ´ÎʹÓõÄʱºò, Ö»ÊÇÖØÐÂÖ´ÐÐSQL.
»¹ÓÐÒ»ÖÖÊÓͼ£ºÎﻯÊÓͼ£¨MATERIALIZED VIEW £©£¬Ò²³ÆʵÌ廯ÊÓͼ£¬¿ìÕÕ £¨8i ÒÔÇ°µÄ˵·¨£© £¬ËüÊǺ¬ÓÐÊý¾ÝµÄ£¬Õ¼Óô洢¿Õ¼ä¡£ ¹ØÓÚÎﻯÊÓͼ£¬¾ßÌå²Î¿¼ÎÒµÄblog£º
Oracle ÎﻯÊÓͼ
http://blog.csdn.net/tianlesoftware/archive/2009/10/23/4713553.aspx
Ò». ÊÓͼµÄÌصã
1. ¼¯ÖÐÓû§¸ÐÐËȤµÄÊý¾Ý. ͨ³£Óû§Ö»ÊǶԱíÖеÄijһ²¿·ÖÊý¾Ý¸ÐÐËȤ, ¶ÔÆäËûµÄÊý¾Ý²»ÊÇÄÇôÃô¸Ð, ËùÒÔÓû§Í¨¹ýÊÓͼ¾Í¿ÉÒÔ²Ù ×Ý×Ô¼ºËùÐèµÄÊý¾Ý. ¶ÔÓÚ¿ª·¢ÈËÔ±À´Ëµ, Ò²¿ÉÒÔÆÁ±ÎһЩÊý¾Ý.
2. ÑÚÂëÊý¾Ý¿âµÄ¸´ÔÓÐÔ. ͨ¹ýÊÓͼ»úÖƽ«Êý¾Ý¿âÉè¼ÆµÄ¸´ÔÓÐÔÓëÓû§ÆÁ±Î·Ö¿ª, ÕâÑùÓû§Í¨¹ýÊÓͼµÄ²Ù×÷¾Í¿ÉÒÔ´ïµ½¼ò»¯¶ÔÊý¾Ý¿âµÄ¸´ÔÓ²Ù×÷.
3. ¼ò»¯Óû§µÄȨÏÞ. ÓÉÓÚÊÓͼֻÊÇ»ù±íµÄÂß¼±í, ËùÒÔͨ¹ýÊÓͼ¿ÉÒÔ½«ÊÓͼµÄȨÏ޺ͻù±íȨÏÞ·ÖÀë.
4. ÖØ×éÊý¾Ý. ÊÓͼ¿ÉÒÔÀ´×Ô¶à¸ö»ù±í, ´Ó¶ø¿ÉÒÔÀûÓÃÊÓͼ¶ÔÊý¾Ý½øÐнøÒ»²½µØ·ÖÎö.
¶þ. ÊÓͼ¿ÉÒÔÓÉÒÔÏÂÈÎÒâÒ»Ïî×é³É:
1. Ò»¸ö»ù±íµÄÈÎÒâ×Ó¼¯
2. Á½¸ö»òÁ½¸öÒÔÉϵĻù±íµÄºÏ¼¯
3. Á½¸ö»òÁ½¸öÒÔÉÏ»ù±íµÄ½»¼¯
4. Ò»¸ö»òÕ߶à¸ö»ù±íÔËËãµÄ½á¹û¼¯ºÏ
5. ÁíÒ»¸öÊÓͼµÄ×Ó¼¯.
Èý. ´´½¨ÊÓͼµÄ»ù±¾Óï·¨:
CREATE[OR REPLACE][FORCE][NOFORCE]VIEW view_name
[(column_name)[,….n]]
AS
Select_statement
[WITH CHECK OPTION[CONSTRAINT constraint_name]]
[WITH READ ONLY]
˵Ã÷:
view_name : ÊÓͼµÄÃû×Ö
column_name: ÊÓͼÖеÄÁÐÃû
ÔÚÏÂÁÐÇé¿öÏ , ±ØÐëÖ¸¶¨ÊÓͼÁеÄÃû³Æ
* ÓÉËãÊõ±í´ïʽ , ϵͳÄÚÖú¯Êý»òÕß³£Á¿µÃµ½µÄÁÐ
* ¹²Ïíͬһ¸ö±íÃûÁ¬½ÓµÃµ½µÄÁÐ
* Ï£ÍûÊÓͼÖеÄÁÐÃûÓë±íÖеÄÁÐÃû²»Í¬µÄʱºò
REPLACE: Èç¹û´´½¨ÊÓͼʱ, ÒѾ´æÔÚ´ËÊÓͼ, ÔòÖØд´½¨´ËÊÓͼ, Ï൱ÓÚ¸²¸Ç
FORCE: Ç¿ÖÆ´´½¨ÊÓͼ, ÎÞÂÛµÄÊÓͼËùÒÀÀµµÄ»ù±í·ñ´æÔÚ»òÊÇ·ñÓÐȨÏÞ´´½¨
NOFORCE:
Ïà¹ØÎĵµ£º
¸ü¸Äoracle Listener ÅäÖãºD:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN Ŀ¼֮Ï£ºListener.oraÎļþ½øÐÐÅäÖãº
# listener.ora Network Configuration File: d:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SI ......
Ò» Ç°Ìá
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
񡜧mytable
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......
×î½üæÓÚ¹«Ë¾µÄÏîÄ¿¿ª·¢£¬ºÜ¾ÃûÓÐÀ´csdnÁË¡£½ñÌìÎÞÊ£¬ÉÏÀ´Ð´µã¶«Î÷¡£¹©´ó¼Ò²Î¿¼£¬²»¶ÔµÄµØ·½»¹Ï£Íû´ó¼ÒÅúÆÀÖ¸Õý¡£
Ò»ÏÂÊǶÔoracleÊý¾Ý¿â±íµÄһЩ²Ù×÷Óï¾ä£º
ÒѾ½¨ºÃµÄ±íÌí¼Ó×Ö¶Î
alter table Tablename add(column1&nb ......
ÈçºÎͨ¹ýSqlplus´´½¨Ò»¸öoracleµÄuser
1£¬Í¨¹ýsystem¹ÜÀíÔ±Á¬½Óµ½ÒªÌí¼ÓUSERµÄDB
»òÕßͨ¹ýÒÔÏÂÃüÁ Connect system/manager@user_datebase AS SYSDBA ;ÒÔSYSµÇ½ȥ´´½¨Óû§
2,´´½¨Óû§²¢·ÖÅäȨÏÞ
drop user asset cascade; ɾ³ ......