I create an Oracle Data Provider for .NET data connection
in the Visual Studio Server Explorer. I right click on Query Window, but I’m only
allowed only one window per data connection.
I would like more than one window per data connection. And
this query window should support multiple Oracle SQL statements separated with
semicolons with the ability to return multiple row sets. Right now I have to rely on creating an Oracle Database Project and creating scripts. But Scripts don't return results in a grid, only as text in the Output window.
Right clicking on New Query one can create multiple query windows,
but these queries don’t show syntax highlighting and they will alter the SQL statement as soon as one runs them,
unlike the preferred behavior of the Query Window.
I would be really nice to have multiple Oracle Query Windows that's closer to behavior to Toad World SQL Navigator.
It is true that ODT will not allow you to have multiple query windows open against the same Server Explorer database connection (eg multiple windows sharing a single connection).
However, if you create multiple Server Explorer connections to the same database then you can have one query window for each of them. Server explorer will not allow you to do this with the exact same connection info so you have to "fool" it. The easiest way to do this is to go into your TNSNAMES.ORA and make a copy of your connect alias. For example, if you have an alias ORCL in TNSNAMES.ORA, you can copy it and call the new alias ORCL2.
The other way to get an extra server explorer connection is to open a second one using the "EZ config" option.,