How to check file format, file size or file validations in oracle apex |...

on

Ckeck or Restrict image format
PLSQL CODE
======================
declare
v_exct nvarchar2(50);
begin
if :P12_PICTURE is null then null;
else
select substr(:P4_PICTURE,INSTR(:P4_PICTURE, '.', -1, 1)+1) into  v_exct from dual;
if v_exct in ('png','PNG','jpeg','JPEG','jpg','JPG','GIF','gif') then
return true;
else 
return false;
end if;
end if;
end;


►►Our Published Video Link :
All type of select search: https://www.youtube.com/watch?v=iW7OKpWt7i8 Procedure base Post Method API: https://www.youtube.com/watch?v=wp67G... Collection A to Z: https://www.youtube.com/watch?v=d3GOd... Delete page Recover: https://www.youtube.com/watch?v=ymWu2... Facebook Authentication: https://www.youtube.com/watch?v=n7sTE... Google Authentication: https://www.youtube.com/watch?v=ZqOzQ... Recaptcha: https://www.youtube.com/watch?v=0K0Fn... Notification Menu: https://www.youtube.com/watch?v=6zlaW... Signature Plugin: https://www.youtube.com/watch?v=NpwjR... Web Source Report: https://www.youtube.com/watch?v=AV-zj... Report Download Plugin: https://www.youtube.com/watch?v=5ofWg... ►► For More Videos, Please Subscribe our Channel: https://www.youtube.com/channel/UCwsr... ------------------------------------------ ►► Our Blog: https://orclapexlearner.blogspot.com/ Thank you

Comments

Post a Comment