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
Ïà¹ØÎĵµ£º
ORACLE sql µÄ´¦Àí¹ý³Ì´óÖÂÈçÏ£º
1.ÔËÓÃHASHËã·¨£¬µÃµ½Ò»¸öHASHÖµ£¬Õâ¸öÖµ¿ÉÒÔͨ¹ýV$SQLAREA.HASH_VALUE ²é¿´
2.µ½shared pool ÖÐµÄ library cache ÖвéÕÒÊÇ·ñÓÐÏàͬµÄHASHÖµ£¬Èç¹û´æÔÚ£¬ÔòÎÞÐèÓ²½âÎö£¬½øÐÐÈí½âÎö
3.Èç¹ûshared pool²»´æÔÚ´ËHASHÖµ£¬Ôò½øÐÐÓï·¨¼ì²é£¬²é¿´ÊÇ·ñÓÐÓï·¨´íÎó
&nbs ......
ǰ¶Îʱ¼ä×öÁËÒ»¸öÐéÄâ×éÖ¯µÄ´´½¨¡£Õâ¸öÐéÄâ×éÖ¯µÄ´´½¨ÊÇ´ÓÏÖÓеÄ×éÖ¯ÖжÁÈ¡Êý¾ÝÈ»ºó½øÐзÖÎö±£´æµ½ÐéÄâ×éÖ¯±íÖС£±£´æÖ®ºóдÈÕÖ¾·½±ãͬ²½µ½ÆäËüϵͳÖС£¹«Ë¾Ê¹ÓõÄÖ÷Òª¼¼ÊõÊÇSSH¡£ÓÉÓÚÊÇÐÂÈËûÓÐʲô¾Ñ飬¼Ó֮ʱ¼ä±È½Ï½ôÆÈ£¬×îºóʹÓÃÒ»°ãµÄÂ߼˼Ïëͨ¹ýµÝ¹éÔÚhibernateÏÂ˳Àû´´½¨ÁË¡£¿ÉÊÇ´ÓÏÖÓеÄ×éÖ¯Ö ......
ÉÏ節學習開µÚÒ»個Form£¬這個節ÔÚÌí¼ÓÒ»個彈³öÏÂÀ¿ò
µÚÒ»²½£ºÌí¼Ó記錄組
1.1 選ÖÐRecord Groups
1.2 單擊Create
1.3 輸Èë²é詢SQL
1.4 單擊OK
1.5 ÐÞ¸Ä ......
nvl( ) º¯Êý
ʾÀý Çë²ÎÔÄ
´ÓÁ½¸ö±í´ïʽ·µ»ØÒ»¸ö·Ç null Öµ¡£
Óï·¨
NVL(eExpression1, eExpression2)
²ÎÊý
eExpression1, eExpression2
Èç¹û eExpression1 µÄ¼ÆËã½á¹ûΪ null Öµ£¬Ôò NVL( ) ·µ»Ø eExpression2¡£Èç¹û eExpression1 µÄ¼ÆËã½á¹û²»ÊÇ null Öµ£¬Ôò·µ»Ø eExpression1¡£eExpression1 ºÍ eExpression2 ¿ÉÒÔ ......
CSDNÀïµÄÒ»¸öÅóÓÑÎʵ½ÁËÕâ¸öË÷Òý¸²¸ÇµÄ¸ÅÄî¡£ Õâ¸ö¸ÅÄîºÜСµÄ֪ʶµã£¬ÔÚÎÒµÄÂÛ̳ÀïÓнâÊÍ“”£¬²»¹ý×÷ΪOracle°æÖ÷£¬²»ÄÜÔÚ»ØÌûÀï¼ÓÉÏÍøÍâµÄµØÖ·Á´½Ó£¬ËùÒÔÕâÀïÔÚCSDNÀïÌûÉÏÒ»·Ý
±ÈÈçÓи´ºÏË÷ÒýΪ3¸ö×ֶΣºf1 + f2 + f3,ÇëÎÊ:
1: select f1, f2, f3, f4 from table where f1 = 'XX' and f2 = 'XX'. ......