Oracle´´½¨´¥·¢Æ÷
½ñÌìÔÚ°Ù¶ÈÉÏËÑË÷ÁËÏÂoracleдµÄ´¥·¢Æ÷£¬¸Ð¾õ»¹¿ÉÒÔ¡£
¾ÍÊղؿ©¡£
Óû§±í£º´´½¨´¥·¢Æ÷֮ǰÊ×ÏÈÒª´´½¨ÐòÁÐ
Óû§±íÐòÁУº
create sequence users_seq;
Óû§±í´¥·¢Æ÷£º
create or replace trigger bifer_users_userid_pk
before insert
on users
for each row
begin
select users_seq.nextval into:new.userid from dual;
end;
/
ÉÌÆ·±í£º
ÉÌÆ·±íÐòÁУºcreate sequence product_seq;
ÉÌÆ·±í´¥·¢Æ÷£º
create or replace trigger bifer_product_itemid_pk
before insert
on product
for each row
begin
select product_seq.nextval into:new.itemid from dual;
end;
/
ÉÌÆ·Æ·ÅÆ±í£º
ÉÌÆ·Æ·ÅƱíÐòÁУºcreate sequence brand_seq;
ÉÌÆ·Æ·ÅÆ±í´¥·¢Æ÷£º
create or replace trigger bifer_brand_brandid_pk
before insert
on brand
for each row
begin
select brand_seq.nextval into:new.brandid from dual;
end;
/
ÉÌÆ·Àà±ð±í£º
ÉÌÆ·±íÐòÁУºcreate sequence class_seq;
ÉÌÆ·±í´¥·¢Æ÷£º
create or replace trigger bifer_class_classid_pk
before insert
on class
for each row
begin
select class_seq.nextval into:new.classid from dual;
end;
/
Ò»¸ö´¥·¢Æ÷Ö»ÄÜÓÃÓÚÒ»¸ö±í£¬¶øÒ»¸ö±í¿ÉÒÔÓÐ×î¶àÈý¸ö´¥·¢Æ÷£¬ÉÌÆ·Æ·ÅÆÀà±ð±íÊǸ´ºÏÖ÷¼üËùÒÔ¾ÍΪÉÌÆ·±í½¨ÁËÁ½¸ö´¥·¢Æ÷·Ö±´×÷ÓÃÓÚÿ¸öÖ÷¼ü
ÉÌÆ·Æ·ÅÆÀà±ð±í£º
ÉÌÆ·Æ·ÅÆÀà±ðÐòÁУºcreate sequence brand_class_seq;
ÉÌÆ·Æ·ÅÆÀà±ð´¥·¢Æ÷(brandid)£º
create or replace trigger brand_class_brandid_pk
before insert
on brand_class
for each row
begin
select brand_class_seq.nextval into:new.brandid from dual;
end;
/
ÉÌÆ·Æ·ÅÆÀà±ð´¥·¢Æ÷(classid)£º
create or replace trigger brand_class_classid_pk
before insert
on brand_class
for each row
begin
select brand_class_seq.nextval into:new.classid from dual;
end;
/
ÔÚoracleÖУ¬ÎªÁË·½±ã³£³£Óô¥·¢Æ÷¼°ÐòÁнáºÏÆðÀ´ÊµÏÖ
ÏȽ¨±í¡¢ÔÙ½¨ÐòÁС¢È»ºóÊÇ´¥·¢Æ÷£¬×îºó²âÊÔ
=============================================
&
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://hi.baidu.com/dashuaiwang/blog/item/47cc680ec35055c37acbe1f8.html
´ò¿ªoracle Êý¾Ý¿âʱ³öÏÖÁË´íÎó:
ORA-00313: ÎÞ·¨´ò¿ªÈÕÖ¾×é 1 (Ïß³Ì 1) µÄ³ÉÔ±
ORA-00312: Áª»úÈÕÖ¾ 1 Ïß³Ì 1: 'D:\ORACLE\ORADATA\GOCOM\REDO01.LOG'
SQL> connect / as sysdba;
ÒÑÁ¬½Ó¡£
SQL> shutdown immediate;
ORA- ......
ÎÊÌ⣺Êý¾Ý¿âΪ£ºOracle Database 10g Release 2
¡¡¡¡²Ù×÷ϵͳΪ£ºWindows Vista/Windows XP MCE(Á½¸ö²Ù×÷ϵͳ·Ö±ð°²×°ºó³öÏÖÏàͬÎÊÌâ)
¡¡¡¡Êý¾Ý¿â°²×°ºó(һ·ĬÈÏÖµ)£¬³¢ÊÔInsertÊý¾ÝºóSelect³öÀ´£¬ÔÀ´µÄÖÐÎÄ×Ö¶ÎÖµ±ä³ÉÁË??????ÐÎʽµÄÂÒÂ룬¸ÃÈçºÎ½â¾ö£¿
¡¡¡¡ÔÚÍøÉϲéÁËһЩ×ÊÁÏ£¬ËµÊÇ·þÎñÆ÷Óë¿Í»§¶Ë×Ö·û¼¯²»Æ¥Å䣬µ«Î ......
ÎÒÃdzõѧÕß°²×°oracleµÄʱºò£¬×Ö·û¼¯Ñ¡ÔñµÄÒ»°ãÊǼòÌåÖÐÎĵĸñʽ£¬Õâ·½±ãÎÒÃÇÓ¢ÎIJ»ºÃµÄ²ËÄñ£¬³ö´íµÄʱºò¶¨Î»´íÎ󣬵«ÊÇÓÐÒ»¸öÎÊÌâ°éËæ³öÏÖ£¬ÎÒÃÇд¹ØÓÚÈÕÆÚµÄsqlµÄÓï¾ä£¬ÎÒÃÇÏëÒªÓ¢ÎĵĸñʽÔõô°ì£¿ÏÂÃæÓÐÁ½¸ö°ì·¨£º
1. Á¬½Óµ½Êý¾Ý¿âºó£¬ÎÒÃÇʹÓÃÈçÏÂÓï¾ä
ALTER SESSION SET NLS_D ......
¸üжàÐеIJ½Ö裺
²½Öè¶à£¬µ«Ð§ÂʱȽϸߣº
1¡¢create table ÁÙʱ±í value (select a.id,a.name,b.name,... from table1 a,table2 b where a.id=b.id)
2¡¢É¾³ýtable1ÖеļǼ£¬²»Òªdrop
3¡¢insert into table1 select ÄãÐèÒªµÄ×ֶΠfrom ÁÙʱ±í¡£
select * from tb_ai03
create table tb_ai031 as select * from tb ......