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:
Post a Comment