oracle字段自动编号,如何高效简洁的获取最新插入数据库的记录的自动编号字段值？...

有什么问题？看不懂。

SQL> create table tables(id number(10),name varchar2(20));

Table created.

SQL> create sequence TABLES_id

2  start with 1

3  increment by 1

4  nomaxvalue

5  nocycle;

Sequence created.

SQL> create or replace trigger TABLES_Trigger

2  before insert on TABLES

3  for each row

4  begin

5  select TABLES_id.nextval into :new.id from dual;

6  end;

7  /

Trigger created.

SQL> insert into tables(name) values ('ZhangSan');

1 row created.

SQL> select TABLES_id.currval from dual;

CURRVAL

----------

1

SQL> insert into tables(name) values ('LiSi');

1 row created.

SQL> select TABLES_id.currval from dual;

CURRVAL

----------

2

SQL> select * from tables;

ID NAME

---------- --------------------

1 ZhangSan

2 LiSi

SQL>

SQL> alter table tables add (clob_col clob);

Table altered.

SQL> insert into tables(name) values ('WangWu');

1 row created.

SQL> select TABLES_id.currval from dual;

CURRVAL

----------

3

SQL> update tables set clob_col='WangWu de CLOB' where id=3;

1 row updated.

SQL> column clob_col format a20

SQL> select * from tables;

ID NAME                 CLOB_COL

---------- -------------------- --------------------

1 ZhangSan

2 LiSi

3 WangWu               WangWu de CLOB