Running multiple SQL statements

[Arjen Visser]

I am a TOAD user switching to PL/SQL developer. In the SQL Window, how can I run mutliple SQL statements like in TOAD where you can run multple SQL statements as scripts.
Now I have to open a new SQL Window for every SQL statement that I need to run as part of my testing.
Example:
truncate table emp;
truncate table dept;
insert into emp select * from ....

I would like to have this all in one SQL Window, and just press F8 to execute this. Is this possible?

 

[rbrooker]

you can use a command window for this.

open a command window, press ctrl-h ( default key ) and this will bring the editor forward. enter your statements here and press f8 ( default key ).

the command window will execute all your statements, one afterthe other.

 

[Arjen Visser]

Thank you very much.