Oracle Forms | How To Create Basic Login Page -38

Опубликовано: 19 Март 2026
на канале: OracleDB Solutions

1,768

Oracle Forms | How To Create Basic Login Page -38
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 easily create a login page with Oracle Forms Builder.

declare
v_record user_info1%rowtype;
begin
:ERR_MESS:='';
select * into v_record from USER_INFO1
where USER_NAME=:CONTROL.USERNAME;
IF
v_record.USER_PASS=:CONTROL.PASS THEN
--:global.USER_NAME:=v_record.USER_NAME;
--:global.memid:=v_record.memid;
IF
v_record.USER_TYPE= 'admin' then
open_form('E:\Micro Credit Project\All Pages\HOME_PAGE.fmx');
elsif
v_record.USER_TYPE='operator' then
open_form('E:\Micro Credit Project\All Pages\member_PAGE.fmx');
elsif
v_record.USER_TYPE='audit' then
open_form('E:\Micro Credit Project\All Pages\group_PAGE.fmx');
end if;
elsif v_record.USER_PASS ():CONTROL.PASS THEN
:ERR_MESS:=('Invalid Password!!');
elsif :CONTROL.PASS is null THEN
:ERR_MESS:=('Please enter username/Password!!');
elsif :CONTROL.USERNAME is null THEN
:ERR_MESS:=('Please enter username/Password!!');
end if;
exception
when others then
:ERR_MESS:=('Invalid Username/Password!!');
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