Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Developer Look & Feel

Posted on 2013-02-06
12
Medium Priority
?
610 Views
Last Modified: 2013-02-20
Ive somehow managed to screw up the SQL Developer looks.
I have managed to remove the list of saved connections on the left of the screen, the SQL worksheet and the output panes etc.

How do I reset it to the default settings?

Thanks
0
Comment
Question by:stummj
  • 6
  • 3
  • 2
  • +1
12 Comments
 
LVL 17

Expert Comment

by:wobbled
ID: 38858979
It is easy to screw up the windows - they are a very easy to put back (I'm guessing you are referring to the SQL server management studio)

http://msdn.microsoft.com/en-us/library/ms166550%28v=sql.105%29.aspx
0
 

Author Comment

by:stummj
ID: 38858995
No sorry - this is SQL Developer (an Oracle product) Still easy to screw up the windows though. At least Oracle and Microsoft are consistent there LOL
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38859035
the "connections" pane => View => Connections

from your a connection, once you connected, you either get a worksheet by default, or you can explicitly open a new worksheet in the context menu
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:stummj
ID: 38859246
How do I get the connections pane back AngelIII?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38859280
which version of SQL Developer do you have?
do you have the "View" menu?
 in that menu, you should have the "connections" item, click it.

otherwise, you may have activated the "auto-hide" of the pane, using the "minimize" button.
can you show a screenshot of your Sql Developer?
0
 

Author Comment

by:stummj
ID: 38859460
Its v1.5.1 and there isnt a "connections" on the view menu :(
Let me get you a screenshot....
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38859532
I have some PC installed with 1.2, otherwise I use 3.0. ..
in both 1.2 and 3.0 I have the view menu with connections item ...
0
 
LVL 23

Expert Comment

by:David
ID: 38860195
I'm away from my PC, but I think you're thinking of the "default" as your set of created connections plus which window(s) open automatically.  Otherwise, a full default suggests that the software be deinstalled, then reinstalled.

If there is another user with a similar set of connections defined, I've seen the list repopulated by exporting / importing the software registry settings.

Preferences for which tools to open should be found in your Options - again from memory.

Does this help?

dvz
0
 

Author Comment

by:stummj
ID: 38860256
I have looked at an install on another pc and I think its somehow completely broken and needs a reinstall. definately no connection on the view menu (but I agree on the pc that is running well it is there!)
0
 
LVL 23

Expert Comment

by:David
ID: 38860364
Strong recommendation, deinstall the existing software; do not just overlay it.
0
 

Accepted Solution

by:
stummj earned 0 total points
ID: 38895122
within documents and settings/user/application data there is a sql developer folder. If you delete that then restart sql developer you get everything reset back to as it was
0
 

Author Closing Comment

by:stummj
ID: 38908732
self answered
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question