SQL> desc t; 名称 空? 类型 ----------------------------------------- -------- ------ ID NUMBER PID NUMBER SQL> create or replace trigger trg_t 2 before insert on t 3 for each row 4 begin 5 :new.id:=:new.id+100; 6 end trg_t; 7 /触发器已创建已用时间: 00: 00: 00.91 SQL> set serveroutput on; SQL> declare 2 v_id number; 3 begin 4 insert into t values(10,20) return id into v_id; 5 dbms_output.put_line(v_id); 6 end; 7 / 110PL/SQL 过程已成功完成。已用时间: 00: 00: 00.80 SQL>
名称 空? 类型
----------------------------------------- -------- ------
ID NUMBER
PID NUMBER
SQL> create or replace trigger trg_t
2 before insert on t
3 for each row
4 begin
5 :new.id:=:new.id+100;
6 end trg_t;
7 /触发器已创建已用时间: 00: 00: 00.91
SQL> set serveroutput on;
SQL> declare
2 v_id number;
3 begin
4 insert into t values(10,20) return id into v_id;
5 dbms_output.put_line(v_id);
6 end;
7 /
110PL/SQL 过程已成功完成。已用时间: 00: 00: 00.80
SQL>