how to run many dml statement with a good vision?

[mqlee]

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.

 

[mqlee]

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.

 

[Marco Kalter]

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.

 

[mqlee]

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.