ROFL! So I went back and looked again, just to be sure.... and I found DBMS OUTPUT on the VIEW menu. LARGE AS LIFE, but I have never SEEN it there before....
Just an FYI. Dbms_Output has been on the View menu since the 2.1 release. Prior to that it was hardwired as a sibling tab to Query Results/Script Output for each Worksheet -- but that caused some confusion for worksheets sharing a connection.
It is quite confusing when you have several tabs and several connections on the go. Will this be the same in v4?
There are no changes of which I am aware in the Dbms_Output view functionality between the 3.2 and 4.0 releases.
As to your point about confusion, keep in mind the following:
1. Each Worksheet tab and Dbms_Output tab include the name of the connection in use. Match on that name when checking output results.
2. Opening multiple Worksheets on the same connection name will share one database connection by default.
3. Multiple Worksheets sharing a database connection also share one Dbms_Output tab. That is by design.
To force worksheets to use unshared connections:
4. Change the default behavior of (2) via Tools -> Preferences -> Database -> Worksheet -> New Worksheet to use unshared connection.
5. Or avoid (4's) overhead of always using unshared connections by opening one-off unshared Worksheets: Ctrl + Shift + N from a shared Worksheet.
6. When using unshared Worksheets, one Dbms_Output tab may be opened per unshared Worksheet. Note that the names of any unshared Worksheets will appear in Dbms_Output's Select Connection dialog drop down list. That should avoid any confusion.
Hope this helps,
Thank you for these additional details. They will be helpful to me as I learn SQL Developer.
Thanks for all the information. I prefer unshared connections so it's good to know I can make them the default.
I suppose I think of the connection as being the "parent", and the individual worksheets/outputs as "children" of that connection. Maybe I've been conditioned by using a different tool in the past, but I feel it would be more intuitive if each connection had a window, and all worksheets/etc for the connection were tabs of that window.