Monday, June 8, 2009

Tabloya eklenen kaydi görmek

create table t
(x int)
/

--Table created.

set serveroutput on
declare
nv int;
begin
insert into t
values (1)
returning x into nv
;
dbms_output.put_line ('son eklenen kayit: '||to_char (nv));
end;
/
son eklenen kayit: 1
/////////////////////////////////////////////////////////////////////
SQL>  declare
x int;
begin
insert into emp (empno)
values ( ( select 100 from dual))
returning empno into x;

dbms_output.put_line ('Last Value Inserted: '||to_char (x));

end;
/
Last Value Inserted: 100

No comments: