用insert吧,不要用select into
解决方案 »
- 有一个大问题,求大家帮帮忙
- 求助一个PL-SQL筛选问题
- 为什么oracle 10G以后数据库文件不能够装在同一目录下?
- 求oracle 8.1.7 for linux
- 超级并发问题
- oracle 主外键!!
- 焦头烂额:如何使用BC对oracle的Blob字段进行操作
- 各位大侠,oracle8i个人版,sql*plus搜索结果都是2
- 重金请教关于oracle中某列nvarchar2类型的比较问题
- Oracle 比较日期范围 结果不准确
- 求解:ORA-01081: cannot start already-running ORACLE - shut it down first
- 菜鳥問題,10到手.
open r_salchgown for
select * from sal_chgown where sal_chgown_id = :new.sal_chgown_id
1、select * into r_salchgown from sal_chgown where sal_chgown_id = :new.sal_chgown_id;----没有分号结束2、所选的查询可能出现多条记录。
AFTER INSERT
ON SAL_CHGOWN
FOR EACH ROW
declare
cursor t_sor(id datatype) is
select * from sal_chgown
where sal_chgown_id=id;
r_salchgown sal_chgown%rowtype;
BEGIN
for v_sor in t_sor(:new.sal_chgown_id) loop
r_salchgown:=v_sor;
end loop;
END;试试看!