Hi,
I typed the below code in oracle 10g express edition.
SELECT emp_id, last_name, salary, dept_id
FROM employees
WHERE emp_id = &employee_num
I get an error; ORA-01008: not all variables bound
Can you pls help?
Thanks.
Hi,
I typed the below code in oracle 10g express edition.
SELECT emp_id, last_name, salary, dept_id
FROM employees
WHERE emp_id = &employee_num
I get an error; ORA-01008: not all variables bound
Can you pls help?
Thanks.
in which tool ?
when i run the query
select * from labours_ir
where manager_id=&mgr_num
order by &col_order
there is an error not all variables bound
in oracle 10g express edition tools sql commands
Are your substitution variables populated?
& is supported only in sql plus and not in oracle EE.
Instead use :
Try this
SELECT *
FROM employees
WHERE emp_id= :employee_num;
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.