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.