oracle²»¿É¸üеÄÊÔͼ
¹Ø¼ü´Ê£ºwith read only
×÷ÓãºÓÃÓÚÖ¸¶¨Ëù´´½¨µÄÊÔͼ²»¿ÉÒÔͨ¹ý±¾ÊÓͼ¸üбí
Ö´ÐÐÒ»ÏÂSQL£¬´´½¨±íT£¬ºÍÁ½¸öÊÔͼV1£¬V2£º
CREATE TABLE T(ID INTEGER);
CREATE VIEW V1 AS SELECT * from T;
CREATE VIEW V2 AS SELECT * from T WITH READ ONLY;
Ö´ÐÐSQL:
INSERT INTO V1 VALUES(1);
--------------------
1 row created
Ö´ÐÐSQL:
INSERT INTO V2 VALUES(1);
--------------------
Ìáʾ´íÎó
µ¥¶ÀµÄSELECTÓï¾ä²»ÄÜʹÓÃWITH READ ONLY
SELECT * from T WITH READ ONLY;
½«²»ÄÜÔËÐС£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ò». ÀûÓÃrowidÀ´µÃµ½Ïà¹ØÐÅÏ¢
SQL> conn sys/admin as sysdba
ÒÑÁ¬½Ó¡£
SQL> create table bl(id number);
±íÒÑ´´½¨¡£
SQL> insert into bl values(1);
ÒÑ´´½¨ 1 ÐС£
SQL> select owner,segment_name,file_id,RELATIVE_FNO,block_id from dba_extents wh
ere owner='SYS' and segment_name='B ......
OracleÒì³£·ÖΪ3ÖÖ:
(1)Ô¤¶¨ÒåÒì³£:no_data_foundµÈ,ÊÇOracleϵͳ¶¨ÒåµÄÒì³£.
declare
s_test varchar2
begin
select id into s_test from test; --´Ëʱtest±íÎÞÊý¾Ý
exception
when no_data_found then
raise_application_error(-20001, 'ûÓÐÊý¾Ý');
end;
(2)×Ô¶ ......
ÒòΪÃ÷°Ú×ŵÄÔµ¹Ê£¬10.2Òý³öµÄTDEЧÄܶÔÁмÓÃÜÒÔºó£¬ÕÐÖÂÏà¸ÉĿ¼ɥʧÁ˶Բ»µÈʽµÄÅжÏÄÜÁ¦¡£
鍫룼
ENCRYPTIONDEMO@fmw//scripts> create table tde_table(id number encrypt no salt,na
me varchar¶þ(30))
¶þ ;
Table created.
Elapsed: 00:00:00.11
ENCRYPTIONDEMO@fmw//scripts> begin
¶þ for i in 1..2 ......
ÔÚ¿ª·¢Ó¦ÓõÄʱºò£¬°ÑÊý¾Ý°´ÕÕÒ»¶¨µÄ¹æÔòÅÅÐòºóÔÙȡǰ¼¸ÌõÊý¾ÝÕâÖÖ²Ù×÷ÊÇºÜÆ½³£µÄÊÂÇé¡£ÎÒÃÇÔÚOracleÖг£ÓõľÍÊÇorder by£¬È»ºóÈ¡µÃrownumСÓÚ¶àÉÙµÄÊý¾ÝÕâÖÖ·½·¨¡£²»¹ýÈç¹û¶ÔOracle²»ÊìϤ£¬Ò²Ðí¾Í»á·¢ÏÖÄãдµÄSQLÓï¾ä¼ìË÷³öÀ´µÄÖµ²»ÕýÈ·£¬Õâ¸öÊÇÎªÊ²Ã´ÄØ¡£ ÒòΪOracleÔÚ¼ìË÷µÄʱºò£¬»áÊ×ÏȰÑÊý¾Ý¶¼¼ìË÷³öÀ´£¬È»ºóÔÚÅÅÐò¶Î ......