I have emp_table(table) having employee details.
The query goes as follows.
SELECT * FROM emp_table WHERE job = 'input()'
I have to give input at run time to select a certain kind of JOB details
my code was:
SELECT * FROM emp_table WHERE job = '&job'
It was giving a syntax error, I'm using POP SQL to write the code, so I don't know if the problem is with editor or if I'm doing it the wrong way.
