I have table EMPLOYEES that has 22 rows of data. If I run in Toad using F5
SELECT * FROM Employees WHERE Last_Name = Grant;
I get result
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- ------------------------- ------------------------- -------------------- --------- ---------- ---------- -------------- ---------- -------------
178 Kimberely Grant KGRANT 011.44.1644.429263 24-MAY-99 SA_REP 7000 .15 149 20
1 row selected.
... but
If I run SELECT * FROM Employees WHERE Last_Name = :x; in Toad using F5, Im not prompted for a variable and I get 0 row selected.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center