Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 798
mik Avatar asked Aug 09 '26 05:08

mik


1 Answers

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.

like image 128
thatjeffsmith Avatar answered Aug 11 '26 01:08

thatjeffsmith