Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Praser doesnt recognize the JOIN TO ONE clause

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/
This post has been answered by Monika Lewandowska on Jul 9 2026
Jump to Answer
Comments
Post Details
Added on Jun 30 2026
1 comment
94 views