I want to use the & symbol to execute a resuable query, such as
SELECT * FROM EMP WHERE EMPNUM = ‘&EMPNUM’;
When I execute the statement above, the SQL Editor should prompts me to enter the value for the employee name at run time.
But in this version (ver-5.5.2) it is not prompting for the value instead it is checking in the table where EMPNUM = ‘EMPNUM’ and hence returning no rows.
Any solutions?
Thanx in advance…
Sujit