VS2008µ÷Óô¥·¢Æ÷ ʹoracle µÄÖ÷¼ü×ÔÔö

ÎÒÒÔÇ°ÊÇÓÃSql server µÄ ÔÚ´´½¨±íµÄʱºò  ¶ÔÒª×ÔÔöµÄ×ֶΠ Ö±½Ó¾Í identity,
ÏÖÔÚ»»Á˹«Ë¾  ÓÃoracleÁË  µ«Õâ¸ö×ÔÔöÎÒûÓÃÃ÷°×, ºóÀ´²éÁËÏ  ˵ҪÏÈ´´½¨ÐòÁР È»ºó´¥·¢Æ÷  ÔÚµ÷Óà ¿ÉÎÒ»¹ÊÇûŪÃ÷°×

ËùÒÔÂé·³¸÷λGG,JJÁË °ï¸öæ
ÔõÑù´´½¨ÐòÁÐ
ÔõÑù´´½¨´¥·¢Æ÷  ²¢Äܵ÷Óà ÐòÁÐ
ÔõÑùÔÚVS2008ÖР µ÷Óô¥·¢Æ÷
ллÁË
×îºÃÏêϸµã...лл

---

´¥·¢Æ÷²»ÐèÒªÄãµ÷Óã¬ORACLE»á´¥·¢ËüµÄ¡£

---

ÒýÓÃ

·½Ê½Ò»£ºÓô¥·¢Æ÷
SQL> create sequence sq1 start with 1;

Sequence created.
SQL> create table t_1(f1 number(10), f2 number(10));

Table created.
SQL> create or replace trigger tr_t_1
  2    before insert on t_1
  3    for each row
  4  begin
  5      select sq1.nextval into :new.f1 from dual;
  6  end;
  7  /

Trigger created.

SQL> select * from t_1;

no rows selected

SQL> insert into t_1(f2) values(10);

1 row created.

SQL> select * from t_1;

        F1         F2
---------- ----------
         1         10

SQL> insert into t_1(f2