How to search record in oracle form 6i?

[Rohullah]

hello
i am new with oracle form 6i,
I want to search record in oracle form6i
i am using this code but i dont know it is not working
what is the reason.
---------------------------------------
select empno,ename,job ,mgr,hiredate,s al,comm,deptno
into:emp.empno, :emp.ename,:emp .job,:emp.mgr,: emp.hiredate,:e mp.sal,:emp.com m,:emp.deptno from emp
where empno=:block4.s earch1;
----------------------------------------

Please Send me the Best answer.

thank u in advance.

[amitpatel66]

Can you please provide more information on what you are exactly looking at? Are you looking for Enter Query and Execute Query to Query data from database table in Oracle forms?