query
SELECT
e.first_name,
e.last_name,
j.job_title
FROM hr.employees e
JOIN TO ONE (hr.jobs j);
Works fine when run as script or in sqlcl
FIRST_NAME LAST_NAME JOB_TITLE
-------------------- ------------------------- -----------------------------------
Bruce Miller Programmer
David Williams Programmer
Valli Jackson Programmer
Diana Nguyen Programmer
Michael Martinez Marketing Manager
Pat Davis Marketing Representative
Susan Jacobs Human Resources Representative
Hermann Brown Public Relations Representative
107 rows selected.
But it triggers an (random :) ) error when executed as a query in VS Code:
Error at Line: 4, Column: 5
SQL Error: ORA-00904: "J"."JOB_TITLE": invalid identifier
*Cause: The identifier or column name entered was invalid.
*Action: Ensure the following
More Details: https://docs.oracle.com/error-help/db/ora-00904/