OraFAQ Forum: Client Tools » SQL Developer Query Result layout

Home » Other » Client Tools » SQL Developer Query Result layout (SQL Developer Version 4.2.0.16.260)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Developer Query Result layout [message #676664]

Mon, 01 July 2019 00:28

vippysharma
Messages: 73
Registered: May 2013
Location: www

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

Report message to a moderator

Re: SQL Developer Query Result layout [message #676676 is a reply to message #676664]

Wed, 03 July 2019 00:29

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

Nobody have any idea?

Report message to a moderator

Re: SQL Developer Query Result layout [message #676677 is a reply to message #676676]

Wed, 03 July 2019 06:23

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: SQL Developer Query Result layout [message #676687 is a reply to message #676677]

Thu, 04 July 2019 01:37

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

thanks for the reference,

Report message to a moderator

Re: SQL Developer Query Result layout [message #676799 is a reply to message #676664]

Wed, 17 July 2019 07:03

Lalit Kumar B
Messages: 3174
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.

Report message to a moderator

Re: SQL Developer Query Result layout [message #676804 is a reply to message #676799]

Thu, 18 July 2019 01:24

vippysharma
Messages: 73
Registered: May 2013
Location: www

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..

Report message to a moderator

Re: SQL Developer Query Result layout [message #677147 is a reply to message #676804]

Thu, 22 August 2019 10:52

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.

Report message to a moderator

Previous Topic:	ERD Best Practices
Next Topic:	can not connect using toad

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:20:53 CST 2025