SQL Developer - automatically refresh a query

Question

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.

if you're fine with a CLI, the REPEAT command will give you exactly what you're looking for in Oracle SQLcl (it's in your SQLDev bin directory) thatjeffsmith.com/archive/2015/04/… — thatjeffsmith
– thatjeffsmith, Commented Jan 31, 2020 at 12:42

thatjeffsmith · Accepted Answer · 2020-01-31 12:41:05Z

5

Yes, turn your query into a user defined report.

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

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

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

answered Jan 31, 2020 at 12:41

thatjeffsmith

22.7k6 gold badges44 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Works, but is there a way to run a report on a database while the connection is busy executing another query? (Unshared report?)

run your long running queries on unshared worksheets whenever possible, otherwise you'd have to create a new connection