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

Oracle ´¥·¢Æ÷,ÐòÁÐÓÃ;

 1¡¢´´½¨±ít1 £ºcreate table t1 (id number,name nvarchar(8))£»
2¡¢´´½¨ÐòÁÐ £ºCREATE SEQUENCE t1_id INCREMENT BY 1 START WITH 1 MAXVALUE
1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER
3. ´´½¨´¥·¢Æ÷ £º
CREATE TRIGGER tig_insert_t1
BEFORE INSERT ON "YINZQ"."T1"
begin
if (:new.id is null) then
select t1_id.nextval into :new.id from dual; //ÆäÖеÄ:new.id Ö¸µÄÊÇt1±íÖÐÐÂÐеÄÁÐ
end if;
end;
Oracle´¥·¢Æ÷Óï·¨
´¥·¢Æ÷ÊÇÌØ¶¨Ê¼þ³öÏÖµÄʱºò£¬×Ô¶¯Ö´ÐеĴúÂë¿é¡£ÀàËÆÓÚ´æ´¢¹ý³Ì£¬´¥·¢Æ÷Óë´æ´¢¹ý³ÌµÄÇø±ðÔÚÓÚ:´æ´¢¹ý³ÌÊÇÓÉÓû§»òÓ¦ÓóÌÐòÏÔʽµ÷ÓõÄ,¶ø´¥·¢Æ÷ÊDz»Äܱ»Ö±½Óµ÷Óõġ£
¹¦ÄÜ£º
1¡¢ ÔÊÐí/ÏÞÖÆ¶Ô±íµÄÐÞ¸Ä
2¡¢ ×Ô¶¯Éú³ÉÅÉÉúÁУ¬±ÈÈç×ÔÔö×Ö¶Î
3¡¢ Ç¿ÖÆÊý¾ÝÒ»ÖÂÐÔ
4¡¢ ÌṩÉó¼ÆºÍÈÕÖ¾¼Ç¼
5¡¢ ·ÀÖ¹ÎÞЧµÄÊÂÎñ´¦Àí
6¡¢ ÆôÓø´ÔÓµÄÒµÎñÂß¼­
´¥·¢Æ÷´¥·¢Ê±¼äÓÐÁ½ÖÖ£ºafterºÍbefore¡£
1¡¢´¥·¢Æ÷µÄÓï·¨£º
CREATE [OR REPLACE] TIGGER´¥·¢Æ÷Ãû ´¥·¢Ê±¼ä ´¥·¢Ê¼þ
ON±íÃû
[FOR EACH ROW]
BEGIN
pl/sqlÓï¾ä
END
ÆäÖУº
´¥·¢Æ÷Ãû£º´¥·¢Æ÷¶ÔÏóµÄÃû³Æ¡£
ÓÉÓÚ´¥·¢Æ÷ÊÇÊý¾Ý¿â×Ô¶¯Ö´Ðеģ¬Òò´Ë¸ÃÃû³ÆÖ»ÊÇÒ»¸öÃû³Æ£¬Ã»ÓÐʵÖʵÄÓÃ;¡£
´¥·¢Ê±¼ä£ºÖ¸Ã÷´¥·¢Æ÷ºÎʱִÐУ¬¸ÃÖµ¿ÉÈ¡£º
before---±íʾÔÚÊý¾Ý¿â¶¯×÷֮ǰ´¥·¢Æ÷Ö´ÐÐ;
after---±íʾÔÚÊý¾Ý¿â¶¯×÷Ö®ºó³ö·¢Æ÷Ö´ÐС£
´¥·¢Ê¼þ£ºÖ¸Ã÷ÄÄЩÊý¾Ý¿â¶¯×÷»á´¥·¢´Ë´¥·¢Æ÷£º                        
insert£ºÊý¾Ý¿â²åÈë»á´¥·¢´Ë´¥·¢Æ÷;
ÈÃoracleʵÏÖ×ÔÔö×Ö¶Î
ÏȽ¨ÐòÁÐ,È»ºó½¨Á¢Ò»¸ö´¥·¢Æ÷ʵÏÖ!
cata0ÊDZíÃû,cata0_idÊÇÐèÒª×ÔÔöµÄ×Ö¶Î!
CREATE SEQUENCE SEQ_cata0
 INCREMENT BY  1
 START WITH  1
 MAXVALUE  9999999
CREATE TRIGGER TRG_cata0 BEFORE
INSERT  ON cata0
FOR EACH ROW begin
   SELECT SEQ_cata0.NEXTVAL
     INTO :NEW.cata0_ID
     from DUAL;
End TRG_cata0;
/***
*@PARAM STNAME ²»Òª´´½¨ÐòÁÐµÄ±í£¬¶à¸ö±íÔòÒÔ“,”¸ô¿ª
**/
CREATE OR REPLACE PROCEDURE PROC_CREATE_SEQ_TRIG(STNAME IN VARCHAR2)
AS
 STRSQL VARCHAR2(4000);
 TABLENAME VARCHAR2(50);
 PID VARC


Ïà¹ØÎĵµ£º

Virtual Columns in Oracle Database 11g

When queried, virtual columns appear to be normal table columns, but
their values are derived rather than being stored on disc. The syntax
for defining a virtual column is listed below.
column_name [datatype] [GENERATED ALWAYS] AS (expression) [VIRTUAL]
If the datatype is omitted, it is determin ......

ASP.NETÅäÖÃOracleµÄÏà¹ØËµÃ÷

 ²        Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
²        Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
²     ......

ORACLE PL/SQL ´æ´¢¹ý³Ì½Ì³Ì


(1)SEQNAME.NEXTVALÀïÃæµÄÖµÈçºÎ¶Á³öÀ´£¿¿ÉÒÔÖ±½ÓÔÚinsert into test values(SEQNAME.NEXTVAL) ÊÇ¿ÉÒÔÓà  ÕâÑù£º     
SELECT tmp#_seq.NEXTVAL
        INTO id_temp
        from DUAL;  È»ºó¿ÉÒ ......

Oracle³£ÓÃɵ¹ÏÎÊÌâ1000ÎÊ


   
´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, ÌØ±ð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ.
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager ......

ÆÀ:Å·ÃË×èÄÓOracle¼æ²¢Sun

 ËäÈ»ÎÒÃÇÖªµÀÉ̵À¹îÒ²,ÕâÆªÎÄÕ»¹ÊÇÄܹ»ÈÃÎÒÃÇ´ÓijЩ½Ç¶ÈÉϹ۲졣±ÈÈçÅ·ÃËÓµ»¤¿ª·Å¼¼Êõ,Å·ÃËÒªÆÀ¼ÛOracleÓµÓÐMySQLºÍJavaËùÔì³ÉµÄÓ°Ïì,everything is politicalÒÑÈ»ÊÇÒ»Ìõ´ó·¹æÔòÁË£¬ÎÒÃÇ»¹ÊÇÄܹ»Ðá³öÕâ¸ö»Ï×ÓÏÂÃæÂôµÃ»¹ÊÇÀûÒæ¹Ï·ÖµÄÀϾÀ¸ð£¬×ܲ»ÄÜɶºÃʶ¼ÈÃÄãÃÀ¹úÀÐÕ¼ÁË¡£µ«ÊÇÎÒÏëÒ²Ö»ÊǸöʱ¼äÎÊÌ⣬ҲÐí±³ºóÍÆÊÖÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ