Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Developer Look & Feel

Posted on 2013-02-06
12
Medium Priority
?
588 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

664 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