Tagged Questions

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

learn more… | top users | synonyms

0
votes
1answer
13 views

What does this “3-line to column” icon indicate about an object in SQL Developer?

In SQL Developer, under Tables, almost all of my tables are just a normal table icon, however, every so often I come across a table that has the icon/image shown below. I wasn't around when some of ...
0
votes
1answer
37 views

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 ...
0
votes
0answers
70 views

How to use backreferences in oracle sqldeveloper find/replace

How do you use backreferences when doing regular expression find/replace in Oracle SQLDeveloper? \n doesn't work for me and neither does $n.
0
votes
2answers
83 views

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 ...
1
vote
0answers
2k views

sql developer cannot establish a connection with db that does have listener running

I am working from home and connected to my work's vpn. I have tried to connect to the work db with sql developer (the latest version and the previous version) on the following environments: mac os x ...
1
vote
1answer
444 views

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
1
vote
4answers
4k views

Sqldeveloper /as sysdba connection

I'm a total newbie in Oracle. I installed Oracle 11g XE R2. Also I installed SqlDeveloper 3.2.20.09 version. I generated auto connections, and I have 2 connections. One is: /as sysdba and ...
1
vote
1answer
336 views

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?
1
vote
1answer
391 views

Code folding in SQL Developer's SQL Worksheet

Is there a way to enable code folding in Oracle SQL Developer's SQL Worksheet? Using version 3.2.20.09.
1
vote
0answers
263 views

Unable to connect DB on a remote server

I have an OpenSUSE OS running under VirtualBox. I can connect to Oracle 11g database with SQLDeveloper from localhost, but when I try to connect it from another PC I have either Io exception: Got ...
1
vote
1answer
1k views

Connect using sqlplus to db server through multiple tunnels

I would like to create an SQL Developer connection to a database through a couple of tunnels. The steps right now are: Connect to server A -> connect to server B -> run sqlplus against tnsname on a ...
0
votes
1answer
2k views

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 ...
1
vote
2answers
13k views

How do I export the data from an Oracle SQL Developer query

How do I export the data from an Oracle SQL Developer query? I can create queries in it fine, but as to export ??
6
votes
3answers
8k views

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 ...
8
votes
7answers
49k views

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 ...
2
votes
3answers
789 views

Free software to replace SQL Developer?

As for a developer, the use of SQL Developer is almost daily. However, given that my laptop have only 1 gb ram, it is hard to open SQL Developer and Eclipse together. Do you have any lighter ...
1
vote
1answer
2k views

SQL developer won't start

Today I tried to open SQL developer and it won't start at all. I am using Windows XP and I haven't been using SQL Developer for 1 or 2 months. Today, when I tried to open SQL Developer, I click the ...
1
vote
4answers
3k views

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.
8
votes
2answers
8k views

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 ...
2
votes
5answers
6k views

Ctrl v does not work in ORACLE SQL Developer

I cannot get Paste ( Ctrl+V ) to work in Oracle SQL Developer
1
vote
1answer
1k views

Oracle SQLDeveloper locks up when using copy/paste

SQL Developer keeps locking up when I copy/paste text in a worksheet. It happens when I past into SQL Developer from itself or from another application and also when I past from Developer into ...