This content has been marked as final. Show 4 replies
even without the picture , just a general idea
what's a PL/SQL code for a search button that when pressed it will select all employees with the same id entered in the search
what other info you need?
Welcome to the forum.
From your link it shows you're using Form Builder as your development tool.
Therefore your question belongs to the Forms Forum @ Forms and not so much in this forum.
Keep in mind to read the FAQ's you'll stumble upon in several forums, so you know what to post and what not to post.
For example, here's the SQL and PL/SQL FAQ:
Re: 3. How to improve the performance of my query? / My query is running slow.
but it didn't workThat;s something you should not post.
Be more specific.
If you get an error message, then post the exact error code and message.
Always mention your database version and your Forms version (if Forms is involved).
975477 wrote:This is not an Oracle Forums forum.
i'm trying to write a PL/SQL for a search button , like in this picture
beginObviously not as the WHERE clause evaluates 2 variables and check whether these 2 variables are equal.
SELECT employee_id , first_name , last_name , manager_id , department_id
:employee_id , :first_name , :last_name , :manager_id , :department_id
FROM EMPLOYEES WHERE :DEP_ID = :DEPARTMENT_ID;
but it didn't work