create or replace function getmax(p_id in varchar2)
return varchar2
as
v_id client_suffer.cls_id%type;
begin
select max(cls_id) into v_id from client_suffer
where cls_id<p_id;
return v_id;
exception
when others then
return '0';
end;
/create or replace trigger CLient_Suffer_Del
after delete on client_suffer
for each row
begin
insert into text(v,uc_id) values('client_suffer_del',getmax(:old.cls_id));
end CLient_Suffer_Del;
return varchar2
as
v_id client_suffer.cls_id%type;
begin
select max(cls_id) into v_id from client_suffer
where cls_id<p_id;
return v_id;
exception
when others then
return '0';
end;
/create or replace trigger CLient_Suffer_Del
after delete on client_suffer
for each row
begin
insert into text(v,uc_id) values('client_suffer_del',getmax(:old.cls_id));
end CLient_Suffer_Del;
解决方案 »
- oracle里的参照完整性有问题吗?
- oracle 数据仓库
- DataReader.Read() 性能问题
- 怎么实现oracle和jdbc中rowid格式的转化
- 我刚刚用database configuration assistant 见了一个oracle的数据库,建完以后我在哪里可以找到这个数据库??我想为这个数据库见一个用户登录到这个数据库,怎样做?
- 出现ORA-00927:缺少等号的警告,请帮忙解决
- 数据库查询问题~100分
- 如何整个数据库进行EXP,IMP? 当我用FULL=Y时会出现User did not exist
- 系统使用GHOST还原后无法启动监听,错误信息如下:
- 成为一名合格的数据库管理员需要学习什么?
- 如何对配置文件进行加密????????
- 9i sql语句高手请进
select max(cls_id) into v_id from client_suffer
where cls_id<p_id;
这里
有没有别的方法