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

ORACLEÎﻯÊÓͼ ÎﻯÊÓͼÈÕÖ¾½á¹¹

http://space.itpub.net/4227/viewspace-68592
ÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂÒªÇó»ù±¾±ØÐ뽨Á¢ÎﻯÊÓͼÈÕÖ¾£¬ÕâÆªÎÄÕ¼òµ¥ÃèÊöÒ»ÏÂÎﻯÊÓͼÈÕÖ¾Öи÷¸ö×ֶεĺ¬ÒåºÍÓÃ;¡£
 
ÎﻯÊÓͼÈÕÖ¾µÄÃû³ÆÎªMLOG$_ºóÃæ¸ú»ù±íµÄÃû³Æ£¬Èç¹û±íÃûµÄ³¤¶È³¬¹ý20룬Ôòֻȡǰ20룬µ±½Ø¶Ìºó³öÏÖÃû³ÆÖظ´Ê±£¬Oracle»á×Ô¶¯ÔÚÎﻯÊÓͼÈÕÖ¾Ãû³ÆºóÃæ¼ÓÉÏÊý×Ö×÷ΪÐòºÅ¡£
ÎﻯÊÓͼÈÕÖ¾ÔÚ½¨Á¢Ê±ÓжàÖÖÑ¡Ï¿ÉÒÔÖ¸¶¨ÎªROWID¡¢PRIMARY KEYºÍOBJECT ID¼¸ÖÖÀàÐÍ£¬Í¬Ê±»¹¿ÉÒÔÖ¸¶¨SEQUENCE»òÃ÷È·Ö¸¶¨ÁÐÃû¡£ÉÏÃæÕâЩÇé¿ö²úÉúµÄÎﻯÊÓͼÈÕÖ¾µÄ½á¹¹¶¼²»Ïàͬ¡£
ÈκÎÎﻯÊÓͼ¶¼»á°üÀ¨µÄÁУº
SNAPTIME$$£ºÓÃÓÚ±íʾˢÐÂʱ¼ä¡£
DMLTYPE$$£ºÓÃÓÚ±íʾDML²Ù×÷ÀàÐÍ£¬I±íʾINSERT£¬D±íʾDELETE£¬U±íʾUPDATE¡£
OLD_NEW$$£ºÓÃÓÚ±íʾÕâ¸öÖµÊÇÐÂÖµ»¹ÊǾÉÖµ¡£N£¨EW£©±íʾÐÂÖµ£¬O£¨LD£©±íʾ¾ÉÖµ£¬U±íʾUPDATE²Ù×÷¡£
CHANGE_VECTOR$$±íʾÐÞ¸ÄʸÁ¿£¬ÓÃÀ´±íʾ±»Ð޸ĵÄÊÇÄĸö»òÄö×ֶΡ£
Èç¹ûWITHºóÃæ¸úÁËROWID£¬ÔòÎﻯÊÓͼÈÕÖ¾Öлá°üº¬£º
M_ROW$$£ºÓÃÀ´´æ´¢·¢Éú±ä»¯µÄ¼Ç¼µÄROWID¡£
Èç¹ûWITHºóÃæ¸úÁËPRIMARY KEY£¬ÔòÎﻯÊÓͼÈÕÖ¾Öлá°üº¬Ö÷¼üÁС£
Èç¹ûWITHºóÃæ¸úÁËOBJECT ID£¬ÔòÎﻯÊÓͼÈÕÖ¾Öлá°üº¬£º
SYS_NC_OID$£ºÓÃÀ´¼Ç¼ÿ¸ö±ä»¯¶ÔÏóµÄ¶ÔÏóID¡£
Èç¹ûWITHºóÃæ¸úÁËSEQUENCE£¬ÔòÎﻯÊÓͼÈÕ×ÓÖлá°üº¬£º
SEQUENCE$$£º¸øÃ¿¸ö²Ù×÷Ò»¸öSEQUENCEºÅ£¬´Ó¶ø±£Ö¤Ë¢ÐÂʱ°´ÕÕ˳Ðò½øÐÐˢС£
Èç¹ûWITHºóÃæ¸úÁËÒ»¸ö»ò¶à¸öCOLUMNÃû³Æ£¬ÔòÎﻯÊÓͼÈÕÖ¾Öлá°üº¬ÕâЩÁС£
 
ÏÂÃæÍ¨¹ýÀý×Ó½øÐÐÏêϸ˵Ã÷£º
SQL> create table t_rowid (id number, name varchar2(30), num number);
±íÒÑ´´½¨¡£
SQL> create materialized view log on t_rowid with rowid, sequence (name, num) including new values;
ʵÌ廯ÊÓͼÈÕÖ¾ÒÑ´´½¨¡£
SQL> create table t_pk (id number primary key, name varchar2(30), num number);
±íÒÑ´´½¨¡£
SQL> create materialized view log on t_pk with primary key;
ʵÌ廯ÊÓͼÈÕÖ¾ÒÑ´´½¨¡£
SQL> create type t_object as object (id number, name varchar2(30), num number);
  2  /
ÀàÐÍÒÑ´´½¨¡£
SQL> create table t_oid of t_object;
±íÒÑ´´½¨¡£
SQL> create materialized view log on t_oid with object id;
ʵÌ廯ÊÓͼÈÕÖ¾ÒÑ´´½¨¡£
½¨Á¢»·¾³ºóÀ´¿´¿´ÎﻯÊÓͼÈÕÖ¾Öаüº¬µÄ×Ô¶¯£º
SQL> desc mlog$_t_rowid
 Ãû³Æ 


Ïà¹ØÎĵµ£º

Oracle È¡µÃµ±Ìì0ʱ0·Ö0ÃëºÍ23ʱ59·Ö59Ãë

--È¡µÃµ±Ìì0ʱ0·Ö0Ãë
select TRUNC(SYSDATE) from dual;
--È¡µÃµ±Ìì23ʱ59·Ö59Ãë(ÔÚµ±Ìì0ʱ0·Ö0ÃëµÄ»ù´¡ÉϼÓ1ÌìºóÔÙ¼õ1Ãë)
SELECT TRUNC(SYSDATE)+1-1/86400 from dual;
--È¡µÃµ±Ç°ÈÕÆÚÊÇÒ»¸öÐÇÆÚÖеĵڼ¸Ìì,×¢Ò⣺ÐÇÆÚÈÕÊǵÚÒ»Ìì
select to_char(sysdate,'D'),to_char(sysdate,'DAY') from dual;
--ÔÚoracleÖÐÈçºÎµÃ ......

OracleÊý¾ÝÐÔÄÜÓÅ»¯

OracleÓ¦ÓÃϵͳµÄÓÅ»¯Ëĸö·½Ãæ
1.¡¡¡¡¡¡ Ó¦ÓóÌÐòSQLÓï¾äÓÅ»¯;
2.¡¡¡¡¡¡ ORACLEÊý¾Ý¿â²ÎÊýµ÷Õû;
3.¡¡¡¡¡¡ ²Ù×÷ϵͳ²ÎÊýµ÷Õû;
4.¡¡¡¡¡¡ ÍøÂçÐÔÄܵ÷Õû.
oracleÓ¦ÓÃϵͳµÄÐÔÄÜÖ¸±ê
1.¡¡¡¡¡¡ Êý¾Ý¿âÍÌÍÂÁ¿;
2.¡¡¡¡¡¡ Êý¾Ý¿âÓû§ÏìӦʱ¼ä.
ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯µÄ¼¸¸ö²¿·Ö
Êý¾Ý¿âÐÔÄÜÓÅ»¯°üÀ¨Èçϼ¸¸ö²¿·Ö£º
1¡¢1¡¢µ÷Õ ......

oracleÊý¾Ýͬ²½

oracleÊý¾Ý¿âͬ²½
ÔÚÁ½Ì¨oracleÊý¾Ý¿âÖ®¼ä²âÊԳɹ¦£¬ÏÂÃæ¾Í×ܽáһϰɣº
ÐèÇó£º
ÏÖÓÐÁ½Ì¨oracleÊý¾Ý¿â·þÎñÆ÷AºÍB(A,B¿ÉÒÔÊÇÔÚͬһÄÚÍø£¬Ò²¿ÉÒÔÊÇÔÚ»¥ÁªÍøÉϵÄÁ½Ì¨¶ÀÁ¢»úÆ÷)¡£AºÍBÀïÓж¼ÓÐtestable±í£¬½á¹¹Ò»Ñù£¬ÏÖÐèÒªµ±A¿âÖеÄtestable±í±ä»¯Ê±£¬B¿âÀïµÄtestableÒ²ÏàÓ¦±ä»¯Êý¾Ý
ÎҵĽâ¾ö·½°¸£º
ÔÚAÖн¨Á¢µ½B¿âµÄ ......

ϸ̸OracleµÄȨÏÞ

ÎÒÃǾ­³£Ì¸¼°OracleµÄȨÏÞ£¬±ÈÈçConnect£¬DBA£¬resource£¬ sysdba, select any
table,
select_catelog_roleÕâÑùһЩȨÏÞ£¬ÈÃÎÒÃÇÑÛ»¨çÔÂҵģ¬ÄÇôÈçºÎÀ´Çø·ÖÕâЩÖÖÀà·±¶àµÄprivilegeÖв»ÖÁÓÚÑÛÃÔÀëÄØ£¬Õâ¸öÎÄÕ½«
»á¶ÔÄãÔÚÕâ·½ÃæµÄÁ˽âÆðµ½°ïÖú¡£
    
 ÒÔÉÏÎÒÃÇ¿´µ½µÄÕâЩȨÏÞ£¬¶¼ÊÇ¿ÉÒÔͨ¹ýg ......

oracle¼òµ¥Óï·¨±Ê¼Ç


 
¡¡
¡¡
DML Data manipulation language
SELECT 
SELECT [DISTINCT] *|ÁÐxx [AS] "±ðÃûxx"[,ÁÐxx "±ðÃûxx"...]
×Ö·û´®Á¬½Ó·û ||, ×Ö·û»òÈÕÆÚÀàÐ͵Ä×Ö·û´®Óõ¥ÒýºÅ’’, ÁбðÃûÓÃË«ÒýºÅ“”¡£Èç¹û±ðÃûÖÐÓпոñ¡¢ÌØÊâ×Ö·û»òÕßÒªÇóÇø·Ö´óСд£¬±ØÐëÓÃË«ÒýºÅ¡£Ä¬ÈÏÇé¿öÏÂÁбêÌâΪ´óд£¬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ