Print Thread
Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run
#65723 05/29/24 09:17 AM
Joined: Feb 2009
Posts: 13
A
Member
OP Offline
Member
A
Joined: Feb 2009
Posts: 13
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

Re: Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run
Anatoliy #65724 05/30/24 08:32 AM
Joined: Aug 1999
Posts: 22,597
Member
Offline
Member
Joined: Aug 1999
Posts: 22,597
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.


Marco Kalter
Allround Automations
Re: Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run
Marco Kalter #65726 06/02/24 06:17 AM
Joined: Feb 2009
Posts: 13
A
Member
OP Offline
Member
A
Joined: Feb 2009
Posts: 13
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.

Re: Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run
Anatoliy #65727 06/03/24 08:50 AM
Joined: Aug 1999
Posts: 22,597
Member
Offline
Member
Joined: Aug 1999
Posts: 22,597
You can click on the "Pin results" button at the bottom right of the SQL Document to pin the currently displayed results.


Marco Kalter
Allround Automations
Re: Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run
Anatoliy #65728 06/04/24 04:21 PM
Joined: Feb 2009
Posts: 13
A
Member
OP Offline
Member
A
Joined: Feb 2009
Posts: 13
Wau. Thank you. Is it possible to pin more than 1 result?

Re: Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run
Anatoliy #65729 06/05/24 08:38 AM
Joined: Aug 1999
Posts: 22,597
Member
Offline
Member
Joined: Aug 1999
Posts: 22,597
Currently you can only pin 1 result. We'll have more result set operations available in the future.


Marco Kalter
Allround Automations

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.054s Queries: 14 (0.018s) Memory: 2.5185 MB (Peak: 3.0399 MB) Data Comp: Off Server Time: 2025-03-27 07:23:26 UTC
Valid HTML 5 and Valid CSS