Login Application with Database Table User in Oracle Apex | Mr Gactack
Hi guys in this video i am going to show you how to create function for login application with database table user in Oracle Apex.
Table:-
create table user_information
(
id number,
user_name varchar2(50),
password varchar2(50),
status char(1)
)
Function:-
CREATE OR REPLACE FUNCTION USER_AUTH_FUNC (P_USERNAME IN VARCHAR2,P_PASSWORD IN VARCHAR2)
RETURN BOOLEAN
AS
MVAL NUMBER := 0;
BEGIN
SELECT 1 INTO MVAL FROM USER_INFORMATION A
WHERE UPPER(A.ID) = UPPER(P_USERNAME)
AND A.PASSWORD = P_PASSWORD
AND A.STATUS = 'Y';
RETURN (TRUE);
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN FALSE;
END;
Oracle Developer , Database , Oracle Apex , Oracle Apex Tutorial , create function for login application with database table user , step by step , how , how to
--------------
if You enjoy this video please Like and Subscribe!
Channel By: Mr Gactack