oracle 触发器编译错误
create or replace trigger update_manager1
before update of sal on emp FOR EACH ROW when (old.job='MANAGER')
declare
avg1 number(7,2);
begin
select avg(sal) into avg1 from empbackup where deptno=:old.deptno ;
if :new.sal> 3*avg1 then
new.sal=3*avg1
end if;
end;
/
编译无法通过 主要是 更新sal的值为另一个平均数的三倍 好像写的有点问题
new.sal=3*avg1 ;
报错在哪，这里少了分号
new.sal=3*avg1
-->:new.sal:=3*avg1;
相关问答：
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
各大老师好，请教一个问题．
我设置了一个oracle字段，varchar(3000),然后插入一条数据长度才1000,就报错了．如：net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
有没有一种方法让导入继续进行而不异常跳出回滚？
ignore=y
你� ......
请问在oracle中如何实现效果就像在SQL Server中"select top " + pageSize + " * from tb_user where id not in (select top " + curPage*pageSize + " id from tb_user) and units_id=1&qu ......
