Delimiter in Edit Window

[NextSequel]

Can someone tell me what I can use in the SQL edit window to delimit statements so I can run multiple statements? In SQL*Plus you can use semicolons. That doesn't work in the SQL Window. A semicolon is considered an error. Is there no way to execute multiple selects as one can do in SQL Programmer and Query Analyzer (MS).

 

[ScottMattes]

One way is to hilite the SQL you want to execute and press F8.

Another way you have to go into the menu under Tools / Preferences, look under the Window Types section, click on SQL Window entry and then check the AutoSelect statement checkbox. Then click the OK button.

Then, in the SQL Window you separate statements with the semi-colon.

 

[Bert Gombos]

Cooool! I didn't know AutoSelect feature.