This content has been marked as final. Show 2 replies
That really is a question for the SQL and PL/SQL forum:
PL/SQL and SQL
But try using another name for the job_id parameter. The query
select ... from jobs where job_id=job_id;returns all rows in the table since job_id = job_id is true for all rows.
salary in employees.job_id%type
Unlikely that salary is the same datatype as job_id. Should be employees.salary%type.