SEARCH QUERY IN FORMS FOR REFERENCE

SEARCH QUERY IN FORMS FOR REFERENCE

Example:

DECLARE
e_id employe.e_id%type;
e_id1 employe.e_id%type;
fname employe.first_name%type;
lname employe.last_name%type;
d_date employe.dob%type;
mobile employe.mobile_no%type;
sal employe.salary%type;
d_id employe.dept_id%type;
begin
select e_id,first_name,last_name,dob,mobile_no,salary,dept_id into e_id1,fname,lname,d_date,mobile,sal,d_id from employe
where :employe.e_id=employe.e_id;
-- :employe.dept_id_id=employe.dept_id;
:employe1.e_id:=e_id1;
:employe1.first_name:=fname;
:employe1.last_name:=lname;
:employe1.dob:=d_date;
:employe1.mobile_no:=mobile;
:employe1.salary:=sal;
:employe1.dept_id:=d_id;
END;