How to run cascade some sql commands?

[Wojtek]

How to run few commands with SQL Window. Each command ends with ";". When I select few commands and try to run them I receive an error:
ora-00911 - wrong character.
Is there any way? I don't like to use PL/SQL block.
regards
Wojtek

 

[Wojtek]

If there is no way, I would add it to Wish list2.

 

[Marco Kalter]

You can use PL/SQL Developer's Command Window to run a script with multiple SQL and SQL*Plus commands at once (see also chapter 7 in the user's guide).

The SQL Window is an interactive tool. You can execute just one single SQL statement at a time (no SQL*Plus commands like "define"), view or edit result set in case of select statements, drill down to foreign key related tables, cursor fields and collections, switch between single-record/multi-record display, view resource statistics and query plans, export data, and so on. It cannot execute multiple statements separated by semi-colons. However, if you go to Tools > Preferences > SQL Window tab page, you can enable the "AutoSelect Statement" preference. Now the SQL Window will recognize that you have multiple statements in the editor, and will execute (and select) just the one under the cursor.

The Command Window is a batch-script and command-line oriented tool, which can execute multiple statements simultaneously and offers a certain level of SQL*Plus compatibility.

 

[birat]

is this something that you think is the right thing or design? Because TOAD and DBArtisan and other MSSQL query analyzer allows running multiple scripts.

Personally, this limitation really SUCKS.

 

[aotte]

It is all about perspective.

Have one window type that does it all:
- Freedom of solution path versus increased change of mistakes

Have a window type for each different approach:
- More rigorous checking versus forced focus on solution path

A typical case of pick your poison.

 

[birat]

Wow. you're brilliant.