ÔÚOracleÖÐÉèÖÃ×Ô¶¯Ôö³¤ÁÐ
¡¾ÊµÏÖ²½Öè¡¿
1. ´´½¨±íblog_info, ¾ßÓÐIDºÍtitleÁ½¸ö×Ö¶Î, ÆäÖÐID½«ÉèÖÃΪ×Ô¶¯Ôö³¤ÁÐ;
2. ´´½¨ÐòÁÐ:
create sequence sq_blog_info
start with 1
increment by 1
nomaxvalue
nocycle
cache 10;
3. ´´½¨´¥·¢Æ÷:
create or replace trigger tg_blog_info
before insert on blog_info for each row
begin
select sq_blog_info.nextval into :NEW.id from dual; --¡ï×¢Òâ: ´Ë´¦µÄ;ÊDZØÐëµÄ
end;
4. ²âÊÔ:
insert into blog_info (title) values('a');
Ïà¹ØÎĵµ£º
OracleÖеÄÐòÁкŹËÃû˼Òå¾ÍÊÇ´´½¨Ò»¸öÐòÁкţ¬¿ÉÒÔÔÚ²åÈë»òÕ߸üеÄʱºòµ÷Óã¬Ï൱ÓÚÊÇÒ»¸öÉú³ÉÆ÷
´´½¨Óï·¨£º
create sequence myse
increment by 1 --Ôö³¤¶È
start with
1 --´ÓÄÄÀïÔö¼Ó£¬¾ÍÊÇ˵ÏÂÒ»¸ö»ñÈ¡µÄÖµ´ÓÕâ¸öÖµ ......
ORACLE 10G for RHEL AS 4 °²×°
ÑéÖ¤°²×°:¼ì²éORACLEËùÐèµÄ³ÌÐòÊÇ·ñ°²×°¾ùÒѰ²×°(»ò¸ü¸ß°æ±¾)
compat-db-4.1.25-9.i386.rpm
compat-gcc-32-3.2.3-47.3.i386.rpm
compat-gcc-32-c++-3.2.3-47.3.i386.rpm
compat-libstdc++-33-3.2.3-47.3.i386.rpm
compat-oracle-rhel4-1.0-5.i386.rpm
gcc-3.4.3-9.EL4.i386.rpm
gli ......
ÃÀ¹úPVH DB´æÔÚÐÐÁ´½Ó.ͨ¹ýÎҵļì²é,·¢ÏÖ,ÎÒÃǵÄDBͬÑù´æÔÚÐÐÇ¨ÒÆºÍÐÐÁ´½Ó.ORACLEµÄdbms_stats.gather_schema_statsÖ»»áÊÕ¼¯ÓÅ»¯Æ÷ͳ¼ÆÐÅÏ¢,²»»á¼ì²â±íµÄ¼Ç¼ÊÇ·ñ´æÔÚÐÐÇ¨ÒÆºÍÐÐÁ´½Ó.(ÎÒÔÏȱ»Õâ¸ö°ü¸øÆÁË,ËùÒÔÖ´ÐÐÍêdbms_stats.gather_schema_statsºóÒ»²éÊý¾Ý×Öµä:USER_TABLES,ÆäÖеÄ×Ö¶Îchain_cntֵȫΪ0).Òª¼ì²â±íµÄ¼Ç ......
×Ó³ÌÐò ÃüÃûµÄpl/sql¿é
create procedure ¹ý³ÌÃû [²ÎÊý1 in|out|in out¡]
¾Ö²¿±äÁ¿ÉùÃ÷
Ö´ÐÐÓï¾ä
in
out
in out
¹ý³ÌÃû(²ÎÊýÀï±í); create or replace
procedure add123 as
i integer;
j integer;
begin
i:=1;
j:=2;
dbms_output.put_l ......
2010-03-12 21:18:52
ÔÚgoogleÀïÒ»ËÑÒ»´ó°Ñ¡£µ«´ó¶à¶¼ÊÇÒ»¸ö°æ±¾¡£ÔÚÕâÀïÎÒҲתÌùһϡ£
תÌù£ºhttp://blog.csdn.net/shongyu/archive/2009/06/01/4233260.aspx
°´ÕÕÈçϲ½Öè½øÐвÙ×÷£º
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefau ......