Print Thread
how to run many dml statement with a good vision?
#60886 01/08/20 11:24 PM
Joined: Dec 2019
Posts: 11
M
mqlee Offline OP
Member
OP Offline
Member
M
Joined: Dec 2019
Posts: 11
let think about this. when you have,let say, 50 insert/update statements. how do you run it ? in oracle sql developer, you just paste them all to sql editor and it will let you know exactly which it's running at.
but on pl/sql developer, you are able to open a command windows, but when you paste them all here, it runs immediately from the 1st statements and you even dont know if all statements paste here. it looks like the pasting is stuck.

can we have dmls also ran in sql window? and with a highlight line like pl/sql developer, that can show you which statement it is running now.

Re: how to run many dml statement with a good vision?
mqlee #60887 01/08/20 11:27 PM
Joined: Dec 2019
Posts: 11
M
mqlee Offline OP
Member
OP Offline
Member
M
Joined: Dec 2019
Posts: 11
and also, for normal select statements. if you have couple of select statements running at sql windows, and you run them all together, can you stop popping couple of result windows ? and just make them in one result window, so developers dont have to switch multiple windows to check the result.... just like sql server management studio if you need an example.

Re: how to run many dml statement with a good vision?
mqlee #60890 01/09/20 09:59 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
If you paste the script in the Command Window with the ECHO option enabled, each individual command will be echoed before execution. This way you can see exactly see where the script is at.

To enable the ECHO option you can execute the SET ECHO ON command or double-click on the ECH button on the Command Window status line. You can also make this the default by including the SET ECHO ON command in the login.sql file.


Marco Kalter
Allround Automations
Re: how to run many dml statement with a good vision?
Marco Kalter #60904 01/12/20 11:13 PM
Joined: Dec 2019
Posts: 11
M
mqlee Offline OP
Member
OP Offline
Member
M
Joined: Dec 2019
Posts: 11
thanks Marco

my point is, is it possible to see all pasted commands in command window while they are running, with a highlight line. not just the running one. like running batch statements in oracle sql developer.
i guess it's impossible.


Moderated by  support 

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.061s Queries: 14 (0.022s) Memory: 2.5090 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-03 17:28:13 UTC
Valid HTML 5 and Valid CSS