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!

Query fails to execute in VS Code but runs in SQL Developer application

Shay CollingsJan 31 2024

I am trying to run the following query in VS Code

select 
* 
from 
dw_schema.stuff_things_f fct 
inner join dw_schema.location_d locd on locd.location_id = fct.location_id and locd.dw_latest_flag = 'Y' 
where 
1=1 
and trunc(fct.stuff_datetime) between to_date('01/01/2023', 'DD/MM/YYYY') and to_date('01/01/2024', 'DD/MM/YYYY') 
and lower(locd.site_location_name) in ('stuff', 'things') 
;

Running this in VS Code returns the following output in the extension log for the SQL developer extension

See attached log file due to size limitations

Running the same query in the legacy SQL Developer application works without error

1-SQL Developer.log

Comments
Post Details
Added on Jan 31 2024
5 comments
405 views