Create New Username and Password For your apex application/Authentication Schemes in Oracle Apex
hello, viewers today we will see how to Create New Username and Password For your apex application/Authentication Schemes in oracle apex
How to create resume | resume kaise banaye | For Freshers & Experienced Both
• how to make resume in mobile | resume...
Top 8 Most Useful Chrome Extensions (2020) | {In HINDI}
• Top 10 Most Useful Chrome Extensions ...
Oracle Apex Tutorial for Beginners step-by-step from starting 🔥🔥🔥🔥😎
• oracle apex tutorial for beginners in...
PayPal Payment Button for website | PayPal account Kaise banaye | Add Credit and Debit Card Button
• How to create paypal account | How t...
Design Login page in Oracle APEX
• Design Login page in Oracle APEX
****** Create New Username and Password For your apex application/Authentication Schemes in oracle apex *******
1) Create New Application
2) Create a table
3) Create a function
4) create a page with fields username and password and on submitting insert values into the tables
5) Now create new Authentication Schemes and make it current
6) Test your application
******************* function create ************************
create or replace FUNCTION "AUTH" //Function name
(p_username in varchar2, p_password in varchar2)
return boolean
as
user_check varchar2(1);
begin
select 'x'
into user_check
from Authentication Schemes //Table name
where upper(USERNAME) = upper(p_username) and PASSWORD= p_password;
--and APP_IDS=&APP_ID.;
apex_util.set_authentication_result(0);
return true;
exception when no_data_found then
apex_util.set_authentication_result(4);
return false;
end AUTH; //Function name
****************Processes ****************
insert into Authentication_Schemes (USERNAME,PASSWORD)
values(:P1_USERNAME,:P1_PASSWORD);
#oracleapex #Authentication_Schemes #oracle_apex_tutorial #learn_oracle_apex #username #password #trending #oracle #frsher