My Oracle Support Banner

SQL Developer Does Not Allow Select On DBA_SCHEDULER_JOBS (Doc ID 1052858.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle SQL Developer - Version 2.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


When trying to query DBA_SCHEDULER_JOBS using SQL Developer you get no results with F9 or the green arrow on the toolbar. The query result window does not show anything and behaves like the query has incorrect syntax. No error messages is displayed.

When pressing F5 or the "Run Script" button on the toolbar it shows the result.

Use F5 (Run Script)
Use previous version (SQL Developer 1.5.5)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.