(
PARAM_APGROUPNAME nvarchar2,
APGROUPID out number
)
as
begin
insert into APGROUP (APGROUPNAME) values (PARAM_APGROUPNAME);
select APGROUPSEQ.currval into APGROUPID from dual;
end;根据output出来的ID找到刚操作的记录。其中APGROUPSEQ是序列,表APGROUP触发器:
DECLARE NEW_ID NUMBER;
BEGIN
SELECT APGROUPSEQ.NEXTVAL INTO NEW_ID FROM DUAL;
:NEW.ID :=NEW_ID;
END;
PARAM_APGROUPNAME nvarchar2,
APGROUPID out number
)
as
begin
insert into APGROUP (APGROUPNAME) values (PARAM_APGROUPNAME);
select APGROUPSEQ.currval into APGROUPID from dual;
end;根据output出来的ID找到刚操作的记录。其中APGROUPSEQ是序列,表APGROUP触发器:
DECLARE NEW_ID NUMBER;
BEGIN
SELECT APGROUPSEQ.NEXTVAL INTO NEW_ID FROM DUAL;
:NEW.ID :=NEW_ID;
END;
解决方案 »
- Red Hat enterprise server release 5 (Tikanga)端口如何改?
- 问一个左连接的问题。。。
- 关于下面的SQL查询语句怎么写!~急!
- 想写个ORACLE在WIN2000下的批处理,用于自动启动数据库.
- 有关oracle客户端软件的问题
- 请问大家在写sql语句时是如何考虑性能问题的?
- 那里有 Oralce 8i 下载??
- 从oracle8.1.7库中导出的数据,在导入oracle8.1.6时报错,如何解决?
- oracle 修改端口后em 端口无法监听
- Oracle SQL问题
- ORACLE的一个查询问题
- 在oracle中如何实现sql server中的print?
ccc varchar2(30);
begin
update test set vvv=2 where vvv=1
returning ggg into ccc;
dbms_output.put_line(ccc);
end;