实现插入varchar2类型数据的时候,自动插入该数据长度的触发器。
create or replace trigger tri_menu
before insert on t_menu_data
for each row
declare
-- local variables here
begin
if(T_MENU_DATA.data is not null)
update T_MENU_data set MENU_SIEZ = MENU_DATA.Length()/2;
end if;
end tri_menu_info;不知道哪儿有问题?
create or replace trigger tri_menu
before insert on t_menu_data
for each row
declare
-- local variables here
begin
if(T_MENU_DATA.data is not null)
update T_MENU_data set MENU_SIEZ = MENU_DATA.Length()/2;
end if;
end tri_menu_info;不知道哪儿有问题?
改成Length(MENU_DATA)/2;
* & = - + < / > at in is
mod not rem then <an exponent (**)> <> or != or ~= >= <= <>
and or like between overlaps || year DAY_
符号 "then" 被替换为 "UPDATE" 后继续。
行:8
文本:update T_MENU_data set DATA_SIZE =length(data)/2;
是应该“before insert”还是“after insert”