Oracle Forms | How To Change User Login Password By Forms -37
Oracle Forms | How To Change User Login Password By Forms -37
To See More Forms Tutorial Click here • Oracle Forms: How to Install Oracle Databa...
To See More Reports Tutorial Click here • Introduction To Database & Out Line The Se...
Dear viewer, In this tutorial you will learn How To Change user login Password in your forms.
Code:
declare
v_count number;
v_pass VARCHAR2(20);
V_id number;
begin
select count(*) into v_count from userinfo
where USERID=:USER_ID AND upper(USERNAME)=UPPER(:USER_NAME);
IF V_COUNT=1 THEN
SELECT PW INTO V_PASS FROM USERINFO
where USERID=:USER_ID AND upper(USERNAME)=UPPER(:USER_NAME);
IF v_pass=:OPASS THEN
IF v_pass=:NPASS THEN
:mess:=('Both old and new pass are same!!');
ELSE
IF :NPASS=:CPASS THEN
:mess:=('Password changed sucessfully!!');
UPDATE USERINFO SET PW=:CPASS
where USERID=:USER_ID AND upper(USERNAME)=UPPER(:USER_NAME);
STANDARD.COMMIT;
ELSE
:mess:=('Confirmed password is not correct!!');
END IF;
END IF;
ELSE
:mess:=('Invalid Password!!');
END IF;
ELSE
:mess:=('Invalid user name!!');
END IF;
END;
To Get more Tutorial Subscribe The Channel
click here / @oracledbsolutions2678
To Get All Post Like The Facebook Page
Click here / oracledbsolutions
Follow us:
Facebook: / oracledbsolutions
Youtube link: / @oracledbsolutions2678
Facebook Group: / 465557066961548
Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780