PL/SQL Trigger to Insert Records in Lowercase

PL/SQL Trigger to Insert Records in Lowercase:

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

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

You may also like...

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.