create or replace TRIGGER tiuda_t_car
BEFORE INSERT OR UPDATE OF v_plate_number,v_car_number,v_car_tel,n_userid or delete ON T_CAR
FOR EACH ROW
/*******************************************************
** 程序类别 : TRIGGER
** 说明:通过trigger实现数据的更新与插入
*******************************************************/
DECLARE
BEGIN
-- IF updating THEN
-- -- IF nvl(:new.c_isdel,'N')='Y' THEN
--
-- MERGE INTO center_carinfo a
-- USING(SELECT n_user_id,v_user_email,v_username,v_name,v_nativeplace ,v_tel FROM t_user WHERE n_user_id=:NEW.n_userid) b
-- ON (a.vehicle_no=:old.v_plate_number)
-- when matched then
-- update
-- set a.driver_name=b.v_name,
-- a.tel=b.v_tel,
-- a.v_carnumber=:new.v_car_number
-- when not matched then
-- insert ( vehicle_no,driver_name,tel,v_carnumber)
-- values(:new.v_plate_number,b.v_name, b.v_tel,:new.v_car_number);
-- end if;
--
--N_USER_ID, V_USERNAME, V_USER_PWD, V_NAME, C_SEX, V_TEL, V_NATIVEPLACE, V_USER_EMAIL, C_ISADMIN, V_HEAD_IMAGE,
-- V_DRIVER_ID, V_LICENCE, V_ORG_NAME, D_REG_TIME, V_NAME_ONE, V_NAME_TWO, V_MOBILE_ONE, V_MOBILE_TWO,
-- V_ADDRESS_ONE, V_ADDRESS_TWO, C_ISDEL, D_DELTIME
IF inserting OR UPDATING THEN
MERGE INTO center_carinfo a
USING(SELECT n_user_id,v_user_email,v_name,v_nativeplace ,v_tel,v_driver_id,v_licence,
v_org_name,d_reg_time,v_name_one,v_name_two,v_mobile_one,v_mobile_two,v_address_one,v_address_two
FROM t_user WHERE n_user_id=:NEW.n_userid) b
ON (a.vehicle_no=:NEW.v_plate_number)
when matched then
update
set a.driver_name=b.v_name,
a.driver_id=b.v_driver_id,
a.licence=b.v_licence,
a.org_name=b.v_org_name,
a.tel=:NEW.v_car_tel,
a.v_carnumber=:new.v_car_number,
a.reg_time=b.d_reg_time,
a.name_one=b.v_name_one,
a.name_two=b.v_name_two,
a.mobile_one=b.v_mobile_one,
a.mobile_two=b.v_mobile_two,
a.address_one=b.v_address_one,
a.address_tweo=b.v_address_two
when not matched then
insert ( vehicle_no,driver_name,driver_id,licence,a.org_name,tel,v_carnumber,a.reg_time,
a.name_one,a.name_two,a.mobile_one,a.mobile_two,a.address_one,a.address_tweo)
values(:new.v_plate_number,b.v_name,b.v_driver_id,b.v_licence,b.v_org_name,:NEW.v_car_tel,
:new.v_car_number,b.d_reg_time,b.v_name_one,b.v_name_two,b.v_mobile_one,b.v_mobile_two,b.v_address_one,b.v_address_two);
end if;
if deleting then
raise_application_error(-20008,'此资料不允许删除!');
end if;
null;
END tiuda_t_car;
分享到:
相关推荐
create or replace trigger insert_person after insert on person for each row begin insert into person2 values(:new.id,:new.name,:new.password); end; create or replace trigger update_person after ...
Parameterized Trigger Plugin 2.25 hpi
Trigger
Trigger 的特性单个作业支持多个条件组合内部条件:充电中\无法检测网络状态\设备空闲支持作业持久化,这意味着可在设备重启时触发支持作业截止时间可根据配置在后台或者主线程中运行作业示例代码:Job job = ...
Oracle Table大全 Form Trigger大全
trigger语法trigger语法 经典语法全
Trigger和TriggerHandler区别
informix procedure&trigger写法教程
数据库触发器样例程序ALTER TRIGGER [dbo].[djh_wt1] ON [dbo].[WT03] FOR INSERTASinsert into djh_wt select yllhdbo.ylmc(yllh) as ylmcjscbzxbmcljzjscwdmczsjchcllb from inserted
USB2.0 Graphics Card(Trigger UV-158FB-128芯片)USB转显卡的驱动 支持硬件ID:USB\VID_0711&PID;_5001 系统要求: 奔腾4处理器1.5G以上,至少256MB内存、USB2.0接口,WINDOWS2000/XP/VISTA操作系统。
Trigger word detection - v1 最后一个编程作业,终于完成了
Squence及trigger建立及删除程序包
热门插件,simple trigger v2.0 从别的网上找的
oracleform常用Trigger的触发时机.pdf
Trigger UV-158FB-128芯片 USB转VGA转换器(USB显卡)驱动程序。其实是我在找云终端Q530的显卡驱动时偶然发现的,找的好辛苦,公布于此,希望下次有人找的时候容易一些。
Pool Trigger Constrain Bundle 7.1.0.unitypackage
go-trigger - golang的全局事件触发器。利用一个ID注册事件,然后就可以在您项目的任何地方触发事件。
multibranch-scan-webhook-trigger.hpi
两套相同的交易系统(针对多头和空头)基于同一 ColorMaRsi-Trigger 指标信号,可在一个智能交易系统中以不同方式配置
PXI_Star_Trigger_16000X23350_132_135PIN_6U PXI模板 AD15以上版本打开