Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
7,791 Comments
Can exports run simultaneously in SQL Developer? I started an export in one session, which seems to be running fine, then opened another session and started another export. The second export “started”, but it’s not exporting any rows.
hii..
recently install the oracle developer 4.0.1 ver on my windows 10 64 bit.
how would i unistall that database..??
same way you installed it – just delete the folder you unzipped it to
also, there’s no database with SQL Developer
Great tool, without a doubt superior to Toad. I move around a lot and prefer SQLDeveloper to TOAD for the simple reason that they can never find the TOAD software key to activate it. Thanks for all your hard work.
Glad to hear you’re enjoying the tool and that it’s a good fit for you. Thanks for the feedback!
Have there been discussions about using PKI for connect logins?
yes actually, next version will support much easier authentication via oracle wallets in both SQLcl and SQL Developer
Hi Jeff, I want to export the “views” that I see when I open up sql. Is this as simple as migrating over the sql app data folder in roaming?
what do you mean by a ‘view’ and when you say, ‘open a sql’ – do you mean, open a .sql file to the Worksheet?
Hi Jeff,
In data modeler, I prefere to create the foregin key column when creating the relation between paraent and child.
When creating the relation, data modeler creates also the column in the child table and generates a name for it, and here is my issue.
the generated column name is formatted like that ( ParentTableName_ParentPrimaryKeyColumnName ).
I want the foreign key column name to be only the same as its referenced column in the parent table like that ( ParentPrimaryKeyColumnName )
every time I modify it manually in the child table after creating the relation.
is there any configurations or preferences in data modeler to achive that?
thank you
I tried to address this in today’s post – let me know if you have questions.
Thank you very much jiff
it worked
Awesome, thanks for the follow-up!
Hi Jeff,
What’s happening with the new release of SQL Developer? When Oracle is planning to release it?
We’re working on multiple products and projects around Cloud and 12.2…it’s coming.
A question about navigation the the PL/SQL editor:
It’s possible to ctrl-click a procedure and SQL Developer will take you to that procedure. So you might do this a few times to drill deep into code to follow the flow. However, there doesn’t appear to be a way to navigate from whence you came. Is this possible in SQL Developer ? If not, how can I put a request in to get in icluded!!! 🙂
There’s a way. Each doc opens up on your desktop. The previous object is still there, and if you navigate back or ‘down’, the curpos is preserved from where you did the click-through. So just use the kb to navigate to the previous document/window.
Hi, Jeff.
I am new to SQL Developer and (since i am TOAD person) i have a simple Q.
Is it possible to open more then one Schema Browser in the left pane? This would be a great help if one needs to work with multiple schema objects.
Thnks in advance.
Mike R.
SQL Developer doesn’t have a Schema Browser like Toad has. In Toad, the Schema Browser has the left and right hand side – and there’s no way to get to the object editor w/o using the left hand side…unless you use their DESC feature.
So, in SQL Developer, you can open as many objects as you want, using only one navigational item – be it our schema browser dock-able panel, or the connections panel.
I talk about how to see two tables at once here – note this tip applies to working with ANY database object.
I’m getting below error while connecting database on SQL Developer Version 4.1.3.20
Failure – test failed : oracle/jdbc/proxy/ProxyFactory
Can you please help with this?
Thanks!
I’m on vacation until Monday.. Try posting this to the OTN Forum.
Hi Jeff,
I am trying to query the below string.I would like to be able to pull out either Skipped or Completed Items. I currently do it using excel (painstakingly). I’m wondering if there is code I can use to pull out only what I want after either completed or skipped. The string is not always the same length, so I am not sure how to do it.
“It beings 14:58:59
Completed: TASK 1
Completed: SOMETHING 2
Skipped: ANYTHING 3
Skipped: WHO 4
Completed: WHAT 5
Auto Play stopped automatically 15:00:59 in 120 seconds”
If I wanted all completed I would like the final result to be:
TASK 1
SOMETHING 2
WHAT 5
Or if I wanted all Skipped I would like the final result to be:
ANYTHING 3
WHO 4
Is there a way to do this, or am I stuck doing it in Excel?
Hi Jeff,
I have installed oracle 11g express edition and also sql developer.
I used sql developer and restarted my laptop. Later, i tried to open sql developer it is directing to oracle web page. I want to use it back please help me with the solution.
It’s sending you to a website? What website? This doesn’t sound like SQL Developer to me.
Hi Jeff,
using sqldeveloper 4.1.3.20 formatter destroys format when assigning multiline text to variables.
Sample code:
DECLARE
v_SQL VARCHAR2(4000) := ‘
SELECT name
FROM person
WHERE ID = :ID’;
BEGIN
…
END;
results in:
DECLARE
v_SQL VARCHAR2(4000) := ‘
SELECT name
FROM person
WHERE ID = :ID’;
BEGIN
…
END;
after formatting. All lines are left aligned now.
Is there any option to tell the formatter NOT to left align text constants?
OR when will the new formatter be available?
Thx,
Dirk
Hey Dirk, I’m on vacation this week, but will check out your code sample with v4.2’s formatter as soon as I get back.
Jeff,
just upgraded to a new 4k monitor
#sqldeveloper font for menus too small. Hard to tell in pic but the report frame is only 1.4 inches. See Pic on twitter https://twitter.com/TR_Rudkin/status/751496845860319232
I can change the font in editor , but is there a way to change the fonts in the memus? I did try both oracle and window Look and Feel
Thanks TR.
Thanks Jeff and Kris Rice The solution exists in the archives
http://www.thatjeffsmith.com/archive/2013/12/how-to-change-the-ui-font-size-for-oracle-sql-developer/
Hi Jeff, thanks for this gread blog!
I have two databases, one for dev and one for production. We use the SQL DM to create the model for our 4GL Environment.
However, we had a major change in development organisation and now the schemas are now called differently. For instance dev.table@dev equals product.table@prod, where it used to be product.table@dev to product.table@prod. I hope you get the gist.
If I try to import a new table from dev to prod, the DM tries to recreate all the objects anew, since he does not know the dev schema and starts with dev.table1, dev.table2 etc.
Is there a way to translate (like with imp-/expdp) schemas with the import? Or when the only way to import one single table (uncheck all the other) to reassign the schema after import?
Cheers,
Marc
You’re doing a data dictionary import in the modeler, and you want the modeler to treat dev.stuff = product.stuff? Just making sure I’m on the same page before I go to figure this out 🙂
Hi,
Is there a setting where I can see the domain name in the table instead of the data type.
Thank You
In the data model/design? Not sure where you mean exactly.
In the Relational Model Design using SQL Developer Data Modeler.
I’ve created a master/child report to monitor certain ODI sessions (master) and tasks within sessions (child). I would like to draw the users attention to tasks of a certain status, for example to display the child row in red for a task with status “E” (one of the columns in the child query). Is it possible to do this (in code perhaps).
Very nice blog btw!
Thanks Brian. Take a look at this – basically you can use basic HTML to mark up cells in a SQL Developer grid style report.
Perfect. Thanks Jeff, and in less time than it took to have lunch! Just what I needed.
If you see anything we can do to support our ODI customers better, drop me an email.
Jeff,
In SQL Developer 4.1.3, when I open a package to edit, a task starts running “Comparing XXX Body subprograms” which is slowing things down, sometimes locking up the session. This wasn’t done automatically in 3.2. Is there a setting to turn this off? I didn’t see one while digging thru the preferences.
Thanks,
David
Try Preferences > Code Editor > Supported Sync Spec & Body and Gutter Nav – disable both of those
Thank you for your quick reply Jeff. That did the trick.
Jeff, I had to disable this on 17.2.0.188 Build 188.1159. “Comparing XXX Body subprograms” which is slowing things down badly.
Hi.
Is it possible to call formal parameter list of function or procedure?
ctrl+space give some advice but not always and look like in your topic “SQLDev can ‘remember’ for you”.
Last version.
hi
I’m having same problem when i’m trying to open sql developer its showing error-
“Unable to open the following configuration file:[c:\app\Pavilion\product\11.2.0\dbhome_1\sqldeveloper\ide\bin\product.conf]”
I’m using windows 8.1 os and oracle 11g 32 bit product .
Thanks in advance.
Is that file there?
You should download sqldev from otn and use that install as it will be much newer.
Hi Jeff,
I’m an Oracle DBA and I’ve been using SQL Developer for many tasks inside our Oracle 12c Database, in our development environment. Sometimes SQL Developer gets too much time to connect using DBA role users (minutes). Or even to run a very simple query returning a dozen of records. Only with DBA users, not with an unprivileged user. Only in SQL Developer, not in SQL*Plus, for instance.
Should it be loading additional data (from dictionary?) and/or experiencing some kind of contention?
Have you ever seen something like that?
Best regards,
APMeire
are there db wait events? have you captured a trace?
there shouldn’t be any issues native to SQLDev that would cause what you’re seeing…you can use the View > Log > Statements panel to see the queries that get sent over jdbc along with the timings in case it’s a SQL issue
Hi,
Have been using the data modeller extensively as a standalone on a local drive. Now a new person has joined the team and he is taking over the modelling. He has successfully installed the software on his machine and had a play and it all seems fine. How do I get the model to him? Will copying the directory to his machine give him access? I am also thinking that putting it on a shared drive means that he could update it and I could access it to review (but not update).
I checked with our tech group and they asked the following “Which file within the files on the C: drive would need to move onto our shared network file space (is there a specific db file to move) and is there a corresponding setting with the modeller to indicate the new path for the db ?”
Unfortunately, we don’t have Oracle.
regards
jsa
Your design will have a .dmd file. There will also be a directory under that, similar name. Zip that up, send it over. Have your colleague open the dmd file in the modeler.
Thanks very much Jeff.
jsa
I am new to running the Database Diff Report utility. I am a developer and I have not been able to run this without errors.
I have cajoled my (so far) cooperative DBA to run it for me, but who knows if I can count on that. Besides, I am supposed to be able to run it I thought!
Question: Is there simple documentation ANYWHERE that will help me get the rights I need to run Database Diff? Why is this so hard?
I have looked and searched your blog and with google, but I cannot find the answer.
Thank you,
john3
you need extremely high level privs on the DD to get the metadata packages to work for objects that you do not own – see this thread, it seems to be on the right track
I would like to export data as SQL Inserts. However, my text fields include line feeds and other special characters. Can SQL Developer be configured to use the quote “q” operator in the export.
For instance consider:
select q'(hello
this is complicated ‘
text that I would like to
see handled
right )’ txt
from dual;
How can this data be exported (understanding that we would never import into dual) in a way that might automatically work by specifying that the quote operator should be used for textual columns?
Hi Jeff – I have a question about using Editions in SQLDev. We’re an EBS 12.2 environment so the application leverages edition based redefinition (EBR) for patching. Sometimes it is useful to be able to look into the new, unimplemented edition to see what version of code is delivered, for example. When I expand editions in SQLDev, I can right-click and I see options to “Open”, “Set Current”, “Create” and “Drop”. I know what the last two do, and open just expands the tree. Set Current scares me; what I really want to do is have it effectively issue, for example, “ALTER SESSION SET EDITION = V_20141127_2225;” so I can browse the alternate edition schemas. The documentation is less than clear to me, any insight?
does the dialog have a SQL page? that would show you the SQL we’re about to run via the OK/Apply button
Good call. I mustered up the courage to click the menu item in a DEV instance and got the prompts/sql window. It shows ALTER SESSION SET EDITION=”V_20141127_2225″ which is exactly what I was hoping for. Thanks!
I appreciate you’re trepidation – too many folks just click on things to see what happens, even in PROD!