pl/sql中:SQL> set serveroutput on;
SQL> declare
2 v_rowid varchar2(20);
3 begin
4 insert into t values('kk') return rowid into v_rowid;
5 dbms_output.put_line(v_rowid);
6 end;
7 /
AAAGGuAABAAAIV1AAFPL/SQL 过程已成功完成。已用时间: 00: 00: 00.30
SQL> select rowid,name from t where name='kk';ROWID NAME
------------------ ----------
AAAGGuAABAAAIV1AAF kk已用时间: 00: 00: 00.40
SQL>
SQL> declare
2 v_rowid varchar2(20);
3 begin
4 insert into t values('kk') return rowid into v_rowid;
5 dbms_output.put_line(v_rowid);
6 end;
7 /
AAAGGuAABAAAIV1AAFPL/SQL 过程已成功完成。已用时间: 00: 00: 00.30
SQL> select rowid,name from t where name='kk';ROWID NAME
------------------ ----------
AAAGGuAABAAAIV1AAF kk已用时间: 00: 00: 00.40
SQL>
谢谢!不过你说的这种方法,包括OO4O,我都能正确地得到ROWID。
我现在想知道在OCCI编程中,如何在新加入一个记录的同时得到该行的ROWID?