Home » SQL & PL/SQL » Client Tools » SQL Developer Query Result layout (SQL Developer Version 4.2.0.16.260)
SQL Developer Query Result layout [message #676664] Mon, 01 July 2019 00:28 Go to next message
vippysharma
Messages: 42
Registered: May 2013
Location: New Delhi
Member

Hello everyone,

I am new to SQL Developer tool, my question is can we turn or enable the multiple query result windows to just one (Toad/SQL server style). If there's a shortcut key for this, that would be super awesome.
Currently for each query run, your results tab is automatically being pinned, causing each new query run to need it's own new tab to display the results, and this is so much annoying Sad . Any lead or help will be highly appreciated Smile .

thanks,
Viplove
Re: SQL Developer Query Result layout [message #676676 is a reply to message #676664] Wed, 03 July 2019 00:29 Go to previous messageGo to next message
vippysharma
Messages: 42
Registered: May 2013
Location: New Delhi
Member

Nobody have any idea?
Re: SQL Developer Query Result layout [message #676677 is a reply to message #676676] Wed, 03 July 2019 06:23 Go to previous messageGo to next message
BlackSwan
Messages: 26588
Registered: January 2009
Location: SoCal
Senior Member
You might get better & faster answer by posting your question to SQLDeveloper forum below

https://community.oracle.com/community/groundbreakers/database/developer-tools/sql_developer
Re: SQL Developer Query Result layout [message #676687 is a reply to message #676677] Thu, 04 July 2019 01:37 Go to previous messageGo to next message
vippysharma
Messages: 42
Registered: May 2013
Location: New Delhi
Member

thanks for the reference,
Re: SQL Developer Query Result layout [message #676799 is a reply to message #676664] Wed, 17 July 2019 07:03 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3149
Registered: May 2013
Location: World Wide on the Web
Senior Member
vippysharma wrote on Mon, 01 July 2019 10:58

Currently for each query run, your results tab is automatically being pinned, causing each new query run to need it's own new tab to display the results
F9 or CTRL + ENTER will run the statement and display it in the Query Result tab below. If you select all statements and then do the same you will get the Query Result tabs for each statement i.e. for 5 queries it will have the output in 5 different tabs respectively.

F5 on the other hand, is used to run as a script and it displays combined output in the Script Output tab. However, you might have to format the output properly for each statement. Also, for a large output it would be difficult to read the Script Output.
Re: SQL Developer Query Result layout [message #676804 is a reply to message #676799] Thu, 18 July 2019 01:24 Go to previous messageGo to next message
vippysharma
Messages: 42
Registered: May 2013
Location: New Delhi
Member

Yes, Agree but unfortunately i want grid type layout in single frame for multiple SQLs in single worksheet and i guess we don't have that option in SQL developer Sad
We also have discussed all possibilities in Oracle Community forum https://community.oracle.com/thread/4278789 but all in vain..
Re: SQL Developer Query Result layout [message #677147 is a reply to message #676804] Thu, 22 August 2019 10:52 Go to previous message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

>>and this is so much annoying
I guess I don't see why this is such a big deal.

The grid layout style in the tool is pretty much stuck to what you see.

Now that being said, we're looking at the next generation of SQL Developer, and sky's the limit there.
Previous Topic: ERD Best Practices
Next Topic: PL/SQL Developer settings FAQ
Goto Forum:
  


Current Time: Sat Aug 24 10:30:12 CDT 2019