Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run

[Anatoliy]

Hello Team.

1. Sometimes in sql file with many SQLs, pl\sql blocks - when I try run particular query (even if it selected) - previous query is run. (queries separated by ";" or "/" (even for sqls)
2. Is it possible to add option to run sql always in read-only mode for the grid (result dataset)?
3. Is it possible to add supporting SQL Macro String recognition ? like q'[]' q'{}'?
4. In pl\sql developer when several queries are run - several tabs with result are created - are you going to add this functionality?

Thank you

 

[Marco Kalter]

Can you provide an example for issue 1?

I have added 2 and 3 to the list of enhancement requests.

About 4: instead of tabs you now have the Code Contents where you can view the results of the queries.

 

[Anatoliy]

Yes, I see your point. I saw at the right side. But in many cases it useful to see result of query to write new one. And when there is one file with many queries -and pl\sql blocks to investigate some issue - to see on the right side - it's good idea - but than maybe it's possible to somehow lock result than see it when other query is writing.

 

[Marco Kalter]

You can click on the "Pin results" button at the bottom right of the SQL Document to pin the currently displayed results.

 

[Anatoliy]

Wau. Thank you. Is it possible to pin more than 1 result?

 

[Marco Kalter]

Currently you can only pin 1 result. We'll have more result set operations available in the future.