PL/SQL Trigger to Insert Records in Uppercase

PL/SQL Trigger to Insert Records in Uppercase:


While Inserting in table the Name Field will always get inserted in Uppercase due to Trigger.

create or replace trigger valdata
before insert
on student
for each row
declare
no number;
begin
:new.name:=upper(:new.name);
end;

Leave a Reply

Your email address will not be published. Required fields are marked *

1 × five =