Super User
Super User

Questions tagged [sqldeveloper]

Oracle SQL Developer is a popular development environment for database architects.

41 questions
25
votes
6 answers

Is there a way to configure the directory SQL Developer uses to save SQL scripts?

Is there a way to configure the directory SQL Developer uses to save SQL scripts? When I do ... File, New, SQL File ... the directory is always set to the \AppData\Roaming\ for my user. I'd like to set the default to a directory in my dev source…
SteveC
  • 2,193
24
votes
2 answers

How to open several tables in different tabs in SQL Developer

I have several schemes and need to open different tables in different tabs from different schemes at the same time. SQL Developer opens the table view in the same tab. Clicking whilst holding Ctrl or Shift doesn't seem to help. Any ideas?
sergionni
  • 765
13
votes
8 answers

Is there a shortcut to switch between tabs on Oracle SQL Developer?

I'd like to be able to switch between 'Query Result' windows, and it's a pain having to use a pointer (mouse/touchpad) each time.
tshepang
  • 3,341
12
votes
13 answers

SQL Developer Error Messages: "Enter the full pathname for java.exe" and "Cannot find a J2SE SDK installed at path"

Yesterday, I downloaded SQL Developer 3 with SDK and was able to use it just fine. After shutting down my PC last night and booting it up again this morning, every time I try to run it, I get this message: "Enter the full pathname for java.exe" I…
oscilatingcretin
  • 5,493
10
votes
4 answers

How to increase memory footprint of SQLDeveloper

I want to use SQLDeveloper with files that are fairly large. However, performance is sluggish (at best) due to a lack of memory. Assuming that it is a Java app, how can I increase the size of memory allocated to the VM?
Michael Easter
  • 301
7
votes
1 answer

SQL Developer: Stop opening a new worksheet when connecting to schema.

Each time I connect to a schema it opens a new worksheet for that schema. Can I stop it doing this?
user1068446
  • 1,480
6
votes
2 answers

no Theme Selector on SQL Developer 17.3

I have been trying to change the theme of SQL Developer, and I am unable to find the theme selector under Environment in the preferences. has it been removed? Normally this is where it would be located.
Malachi
  • 1,063
5
votes
2 answers

Why can't I open SQL Developer when I have Java 10 installed?

In my Mac terminal: $ javac -version javac 10.0.1 I open SQL Developer and get this dialog: SQL Developer requires a minimum of Java 8. Java 8 can be downloaded from: http://www.oracle.com/technetwork/java/javase/downloads/ How do I get SQL…
Henry Yang
  • 155
5
votes
2 answers

Improve SQL developer performance at query builder

I use Oracle SQL Developer (version 17.3.1.279) in Windows 10 64 bit. It's connected to an Oracle database in the network through TNS. Whenever I open "query builder" first time for a query, or after some changes in the SQL code it takes a lot of…
Máté Juhász
  • 22,071
5
votes
1 answer

Prevent SQL Developer opening table design on click

I'm using SQL Developer 4.1.5.21 (under Windows 7 Professional 64 bit). (I've just downloaded latest version (17.3) and the issue is still the same.) Whenever I click or select a table name in the left pane it opens immediately. How can I prevent…
Máté Juhász
  • 22,071
4
votes
1 answer

Export xls with dates from Oracle SQL Developer

Does anyone know how I can export an excel file from SQL developer with the fields formatted correctly? In particular the date and time columns. Thanks
RNJ
  • 195
4
votes
7 answers

Ctrl v does not work in ORACLE SQL Developer

I cannot get paste (Ctrl+V) to work in Oracle SQL Developer.
user32432
  • 41
3
votes
2 answers

SQL Developer 4 Toolbar

Recently my SQL Developer toolbar became messed up. I'm not sure what I did, and I can't change it back. When I got to View-->Show toolbars-->Customize Main Toolbar, it just says "initializing" and never says anything else. Is something corrupt? Is…
ahartman89
  • 31
3
votes
5 answers

Oracle SQL Developer - How to add folders to frequently used locations in Open Folder interface

How do you add folders on the left side of the Open Folder interface? In one of my previous versions of the installation I had a couple different folders I frequently used in that part of the interface. Now I can't figure out how I got them…
JustAGuy
  • 41
3
votes
1 answer

Oracle SQL Developer update

I am trying to update my Oracle SQL Developer 4.1.2.20. When I select components such as MySQL JDBC Driver or Perforce Extension then I am asked to log in using my Oracle Web Account. This is when the problem starts. With my login and password there…
Jagger
  • 151
1
2 3