but it didn't workThat;s something you should not post.
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