Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.70K
1 Posted Topic
create or replace trigger t2 before insert on table_name for each row declare v_name varchar2(20); begin for i in 0..9 loop if instr(:new.column_name,i)>0 then Raise_application_error(-20001,'you can not insert numeric datatype in varchar datatype'); end if; end loop; end;
The End.