Search This Blog

Thursday, July 20, 2017

Create Validation

Code Editor PL/SQL Function Body Returning Error Test:

declare
v_test varchar2(50);
begin
select last_name into v_test from employees where last_name= :P4_LAST_NAME ;
if
v_test IS  NULL then
return null ;
else
return 'This name is not available' ;
end if;
exception
when others then
return null ;
end ;

No comments:

Post a Comment

Restrict File Upload by File Type in Oracle Apex

If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --...