Home » SQL & PL/SQL » Client Tools » SQL Developer Shortcut (Oracle 10g)
SQL Developer Shortcut [message #515124] Fri, 08 July 2011 02:57 Go to next message
s4.ora
Messages: 54
Registered: March 2010
Member
Hi All,

Is there a shortcut to get the Select Connection Dialog box in SQL Developer?

Every time I need to execute a Query I have to use the mouse to change the Connection, if there is any Shortcut then that would be easier for me to wotk with.
Re: SQL Developer Shortcut [message #515211 is a reply to message #515124] Fri, 08 July 2011 11:25 Go to previous messageGo to next message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Hold Ctrl and keep pressing Tab.
Looks like it is going result, current selection, connection and the list.

By
Vamsi
Re: SQL Developer Shortcut [message #519017 is a reply to message #515211] Mon, 08 August 2011 22:43 Go to previous messageGo to next message
luc_tran
Messages: 31
Registered: October 2010
Location: Viet Nam
Member

If your SQL worksheet has not connected any database, just press F9 to execute the query, system will automatically prompt you to select the connection.
If you have already connected to a database, I don't think we can change the database connection on that SQL worksheet. You need a new worksheet, press Alt+F10 then.

Regards,
Luc
Re: SQL Developer Shortcut [message #519477 is a reply to message #519017] Fri, 12 August 2011 10:23 Go to previous messageGo to next message
pablolee
Messages: 2617
Registered: May 2007
Location: Scotland
Senior Member
Quote:
I don't think we can change the database connection on that SQL worksheet
This is not true (not on the version that I currently use anyway. Top right corner of the worksheet, pull down with your connections available.
Re: SQL Developer Shortcut [message #520824 is a reply to message #519477] Wed, 24 August 2011 21:16 Go to previous messageGo to next message
luc_tran
Messages: 31
Registered: October 2010
Location: Viet Nam
Member

You're right pablolee, a new feature to me. Thanks for telling me that
Re: SQL Developer Shortcut [message #524527 is a reply to message #520824] Sat, 24 September 2011 10:42 Go to previous messageGo to next message
s4.ora
Messages: 54
Registered: March 2010
Member
Quote:

This is not true (not on the version that I currently use anyway. Top right corner of the worksheet, pull down with your connections available.


Hay guys... how can I do it without using a mouse on the same worksheet?
Re: SQL Developer Shortcut [message #524557 is a reply to message #524527] Sat, 24 September 2011 14:33 Go to previous messageGo to next message
BlackSwan
Messages: 22787
Registered: January 2009
Senior Member
>Hay guys... how can I do it without using a mouse on the same worksheet?
why do you insist upon using a GUI; but without using a mouse?
Re: SQL Developer Shortcut [message #524570 is a reply to message #524557] Sat, 24 September 2011 18:23 Go to previous messageGo to next message
pablolee
Messages: 2617
Registered: May 2007
Location: Scotland
Senior Member
BlackSwan wrote on Sat, 24 September 2011 20:33

why do you insist upon using a GUI; but without using a mouse?

Great question!
Re: SQL Developer Shortcut [message #524576 is a reply to message #524527] Sat, 24 September 2011 21:13 Go to previous message
flyboy
Messages: 1770
Registered: November 2006
Senior Member
s4.ora wrote on Sat, 24 September 2011 17:42
Hay guys... how can I do it without using a mouse on the same worksheet?

Have you considered to use online help (rightmost item in main menu or F1 key)?
There are two keywords which you might be interested in: "SQL Worksheet" and "accelerator keys". The second one points to Tools menu -> Preferences -> Accelerators tab, where all of them are configurable. Maybe you will be able to find "database connection drop-down list" or something like that there, but it is not present in my version. Maybe you will have more luck.
Previous Topic: Generate Insert script for existing table data
Next Topic: Advice on Best way to create this Report
Goto Forum:
  


Current Time: Wed Sep 17 20:51:08 CDT 2014

Total time taken to generate the page: 0.24521 seconds