Executing Multiple SQL Statements

[Gordon Bell]

I frequently need to run multiple SQL statements in a row (DELETE, INSERT). Is there a way to run multiple SQL statements in a SQL Window and leave my computer? I realize I could create a SQLPlus command script separating the SQL statements with \, but I would like to know if I can do this in PL/SQL Developer.

Thanks,
Gordon Bell

Example SQL Window:

delete from t006045
where alloc_run_id in
(
select alloc_run_id from t006040 a
where a.submitted_by in ('TEST1', 'TEST2')
)

delete from t006041
where alloc_run_id in
(
select alloc_run_id from t006040 a
where a.submitted_by in ('TEST1', 'TEST2')
)

delete from t006040 a
where a.submitted_by in ('TEST1', 'TEST2')

 

[Jean-Paul Finne]

You can use the command window.

Enter your sql statements in the editor (separated by /) and then press F8.