这句sql哪里有问题，大神帮忙看看

create or replace trigger USERSS_ID before insert on USERINFO
for each row
declare
temp number;
begin
select case
when max(id)<>0 then max(id)+1
else 1
end
into temp from UserInfo;
select temp into :new.id from dual;
end;