Search code examples
oracle-sqldeveloper

SQL Developer - automatically refresh a query

Is there a way to automatically refresh my own query in Oracle SQL Developer?

Something like Tools/Monitor Sessions.../Refresh but for any provided query.

Solution

  • Yes, turn your query into a user defined report.

    enter image description here

    You can right-click on your query result grid in the worksheet -

    enter image description here

    Then if you want a new one, i'd just keep the one and edit the report properties for your new query.

    enter image description here

    Doesn't have to be a grid either - you can have a report of type script. Or use charts. Or a lot more.