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,937 Comments
i am using
Oracle SQL Developer 4.1.0.19
Version 4.1.0.19
Build MAIN-19.07
IDE Version: 12.2.1.0.42.150416.1320
Product ID: oracle.sqldeveloper
Product Version: 12.2.0.19.07
Component Version
========= =======
Oracle IDE 4.1.0.19.07
Java(TM) Platform 1.8.0_45
Versioning Support 4.1.0.19.07
I have Oracle client 11.2.0 in my PC.
have manually updated C:\Oracle\product\11.2.0\client_1\jdbc\lib folder with oracle 12c jars as my DB is in 11.2.3.
When i verify the connection settings , I am getting the below error. pleas e let me know what i am missing
Error Msg:
Testing the Oracle Home located at C:\Oracle\product\11.2.0\client_1
Testing client directory … OK
Testing loading Oracle JDBC driver … OK
Testing checking Oracle JDBC driver version … OK
Driver version: 12.1.0.1.0
Testing testing native OCI library load … Failed:
Error loading the native OCI library
The native OCI driver could not be loaded. The system propertyjava.library.path contains the entries from the environment variable PATH. Check it to verify that
the expected native library directory C:\Oracle\product\11.2.0\client_1\bin is present and precedes any other client installations.
java.library.path = C:\Program Files\Java\jdk1.8.0_45\jre\bin;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windows;C:\Perl\site\bin;C:\Perl\bin;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\tibco\tibrv\8.2\bin;C:\tibco\tibrv\8.1\bin;C:\Program Files\Intel\iCLS Client\;C:\windows\SYSTEM32;C:\windows;C:\windows\SYSTEM32\WBEM;C:\windows\SYSTEM32\WINDOWSPOWERSHELL\V1.0\;C:\PROGRAM FILES\COMMON FILES\LENOVO;C:\PROGRAM FILES\COMMON FILES\ROXIO SHARED\10.0\DLLSHARED\;C:\PROGRAM FILES\COMMON FILES\ROXIO SHARED\DLLSHARED\;C:\PROGRAM FILES\INTEL\SERVICES\IPT\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\IBM\WebSphere MQ\bin;C:\Program Files\IBM\WebSphere MQ\tools\c\samples\bin;C:\Oracle\product\11.2.0\client_1\bin;C:\Program Files\CVSNT\;C:\Program Files\Bitvise SSH Client;C:\Oracle\product\11.2.0\client_1\bin;.
I think you need to take off the ‘/bin’ and try reading this
I tried to remove the /bin from PATH and faced the same error.
Am i missing something in my configuration. I couldn’t figure it out.
Kindly help me..
Testing the Oracle Home located at C:\Oracle\product\11.2.0\client_1
Testing client directory … OK
Testing loading Oracle JDBC driver … OK
Testing checking Oracle JDBC driver version … OK
Driver version: 12.1.0.1.0
Testing testing native OCI library load … Failed:
Error loading the native OCI library
The native OCI driver could not be loaded. The system propertyjava.library.path contains the entries from the environment variable PATH. Check it to verify that
the expected native library directory C:\Oracle\product\11.2.0\client_1\bin is present and precedes any other client installations.
java.library.path = C:\Program Files\Java\jdk1.8.0_45\jre\bin;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windows;C:\Perl\site\bin;C:\Perl\bin;C:\Program Files\IBM\WebSphere MQ\Java\lib;C:\tibco\tibrv\8.2\bin;C:\tibco\tibrv\8.1\bin;C:\Program Files\Intel\iCLS Client\;C:\windows\SYSTEM32;C:\windows;C:\windows\SYSTEM32\WBEM;C:\windows\SYSTEM32\WINDOWSPOWERSHELL\V1.0\;C:\PROGRAM FILES\COMMON FILES\LENOVO;C:\PROGRAM FILES\COMMON FILES\ROXIO SHARED\10.0\DLLSHARED\;C:\PROGRAM FILES\COMMON FILES\ROXIO SHARED\DLLSHARED\;C:\PROGRAM FILES\INTEL\SERVICES\IPT\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\IBM\WebSphere MQ\bin;C:\Program Files\IBM\WebSphere MQ\tools\c\samples\bin;C:\Oracle\product\11.2.0\client_1;C:\Program Files\CVSNT\;C:\Program Files\Bitvise SSH Client;;.
Hi Jeff,
How can I change the SQLPROMPT in SQL Developer.
I tried this:
SET sqlprompt “_user’@’_connect_identifier>”
which works in SQL*Plus, plus all I see in SQL Developer is:
>
don’t think you can
Hi Jeff,
Is it possible to start sql developer, and when it opens a sql worksheet on a predefined database with sql-statement is opened automatically?
Thanks,
Micha
Not today
Hi, Jeff
Is there way to import models from ERwin or ER/Studio Data Architect?
I have several quite big diagrams i will have to port to Data Modeler if decide to switch to this tool.
Sincerely
Alek
Sorry, no.
You would need to import a ddl script or live database that reflects those designs.
Hello Jeff,
I am not able to resolve
‘Please specify the path of JDK home’
I tried with path .
C:\Program Files (x86)\Java\jre1.8.0_45
C:\Program Files (x86)\Java\jre7
I have two Java versions on my machine. (tried disabling 7 enabling 7 and vice-versa )
please advise.
You supplied a jre, but we need a jdk.
I see when doing a query in a worksheet the print icon, and that does offer the headers. I was trying from a “user defined report”. The icon is not offered there, only the file>print [preview] which does not seem to include the headers.
For a report, better to use the built in PDF support.
Using the built in print (print preview) option how do I include the column names as headers? [ Version 4.1.0.19]
Where are you printing from? What editor exactly?
Directly from SQLDeveloper. File>Print Preview gets no headers.
yeah, but I can File > Print from any editor in SQL Developer. Did you run a query in a worksheet? Browse a view?
Hi Jeff
Since updating to Version 4.1.0.19 Build MAIN-19.07
The script output has started to wrap and has a page size of about 10 lines.
So if I am developing some meta data I can’t just copy and paste.
UNLESS I enter:
set LINESIZE 4000
/
set pagesize 50000
/
it then ouputs in a manner that I can cut and paste.
Can this be setup anywhere? I can’t seem to find it.
Before it outputted as if these had been set already
the defaults have changed, but you can set them to your liking by creating a login.sql script and configuring SQLDev to print your output as desired
Yup
Worked fine, but….
One wonders why we have a comprehensive preferences function and it is not in there?
Oh well, many thanks for your reply and solution.
Marcus
There are DOZENS of script execution parameters, having pages of them makes no sense. Just set what you want in a single file, and you’re done.
Hi Jeff,
Is there any way to save database credentials permanently in sql developer. Every time i closed and open i have to connect again by providing credentials.
you mean passwords? just click the ‘save password’ option on the connection properties dialog
Hi Jeff–
I am using Oracle SQL Developer 4.1 final release. Oracle Database is Saving the various Language data (Tamil Hindi English) successfully. I am able to fetch and save it in the DB. But I am not able to see the data in proper Language in the Results of the SQL Developer. Please let me know If I need to change some of the settings or need to download any language Pack or Add-ons
Thanks
Sayam
It’s always about the font. What’s your code editor display font, AND does it support your Tamil/English characters?
I recently upgraded an extension for SQLDeveloper using Jdeveloper 12c and Jdeveloper esdk, to work on version 4.0.3. However now the extesion would not load on sqlDeveloper 4.1 nor am i able to develope and Extension via Jdeveloper 12c (latest version) for 4.1 crashes when targeting folder with sqldeveloper.boot file.
any hint as to what changes are required to get extension to support the latest version?
Jeff,
I loved the history feature. When I copied a few of the history items, I lost all history and new queries are no longer being saved. What did I change?
Copied them how exactly? I don’t know what you did, so not sure what you changed, if anything.
Jeff,
I am using version 3.2.20.09 to manage and update JD Edwards tables. One table (F00165) has a BLOB field that I need to edit. Some of the BLOB text has tags in it as users tried to convert from RTF to HTML. I need to remove the tags so the information displays correctly on screens and excel exports. Is there a way to make this change or do I need a BLOB editor tool to make the change? If a tool is needed, what to you recommend
save the blob to a local file, make the changes, and load it back up..i have a post or 3 about Blobs here, use the Search to find them
Hi Jeff ,
I have been experiencing GUI drawing problems within Windows 8.1 Pro(x64) with 64Bit JDK 8u45.Adding the JVM property “sun.java2d.noddraw=true” has no effect. The drop down menus are not correctly rendered. In addition some window controls are missing in the dialog boxes. I have opened an issue regarding to this in stack overflow (http://stackoverflow.com/questions/30246253/oracle-sql-developer-4-1-menus-are-not-correctly-drawn?noredirect=1#comment48594232_30246253)
Could you tell me what causes this problem and how to fix it ?
Thanks in advance
It’s most likely Windows 8.1 issues with Java Swing apps..there should be other stackoverflow posts on there that get you closer if you add ‘swing’ to your search
Hello Jeff,
Thanks for the reply. I’ve looked over the posts regarding the Swing issues in stack overflow but I have not found a solution yet; They are all discussing about passing some flags to the JVM (For instance : Dsun.java2d.d3d etc.) to change the widget’s rendering. If you can point me the right direction, I’ll be glad.
passing flags to the JVM can be done via the product.conf file
Hmm I edited the “sqldeveloper.conf” to add these property files
i.e:
AddVMOption -Dsun.java2d.noddraw=true
AddVMOption -Dsun.java2d.d3d=false
So do I need to add them to product.conf instead of sqdeveloper.conf ?
correct
ok now I put them in product.conf but that did not work: still getting the same issue.
back to stackoverflow, or you can open an Service Request with My Oracle Support
Hi Jeff,
When I test the Instant Client in SQL Developer (4.1.0.18) on my macbook pro (OS X 10.10.3), I get the following output:
Testing testing native OCI library load … Failed:
Error loading the native OCI library
The native OCI driver could not be loaded. The system propertyjava.library.path contains the entries from the environment variable DYLD_LIBRARY_PATH. Check it to verify that
the expected native library directory /opt/oracle/instantclient_11_2 is present and precedes any other client installations.
java.library.path = /Users/lalevesque/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:
How do I get this up and running correctly?
the error message says it all, verify that DYLD_LIBRARY_PATH has the directory for your instant client install. Also, make sure it’s an 11204 or 12102 instant client
I have set the DYLD_LIBRARY_PATH as shown in the instant client install instructions, and it is an 11204 instant client. Any other thoughts on this? I’ve tried almost everything I can find on your site and others with no luck.
show me your path
It is set to /opt/oracle/instantclient_11_2.
looks right, make sure it’s early in the directory list so it doesn’t find a stray OCI driver from another entry in the path
Hi Jeff,
What has happened to the “Forward Engineering Strategy” field available in SQL Developer Data Modeler V3.0? In V3.0 you see it when you double click an entity in the logical model, i.e Entity Properties, in the “General” section. It is not there in V4.
Thanks.
John
Jeff,
If I spool in sqlcl using set sqlformat ansiconsole, my heading have extra characaters. Any way to ‘fix’ that? here is an example:
[4;1mUSERNAME
Also, do you have to be using a linux client in order for the text highlight coloring to work?
Love the tool so far!
Thank you,
Scott
Hi Jeff,
is there a way to get demonstrations on the use of SQL parser in SQLDeveloper? I would like to parse PL/SQL code and to get the AST tree.
Regards
Falsch?
Google Übersetzer für Unternehmen:Translator ToolkitWebsite-Übersetzergoogle
Sofortübersetzung deaktivierenÜber Google ÜbersetzerMobilCommunityDatenschutzerklärung & NutzungsbedingungenHilfeFeedback geben
Try asking Vadim on his blog, but it’s not a product or technology we make available as far as I know.
I want to make sure that only one instance of sqldeveloper can start at any given time. Some other softwaere has an option for this behaviour but i did not find any cue in the software or on the net.
Thanks for your work !
Norbert
Why, are you accidentally opening a new copy of the tool when you don’t mean to? We don’t have any application logic to prevent that today.
Hi Jeff,
do you have a rough date, when SQL Developer 4.1 with JDK included will be released? So I would not have to check twice a week :-))
And yes, I saw your post http://www.thatjeffsmith.com/ask-a-question/#comment-84751 above.
Thanks, Mark
quit checking, i’ll just let you know when it’s ready
or if you can’t wait, just put it down yourself. zip it up on another machine, and unzip it down on your work machine
Hi Jeff,
some comments on the SQL Data Modeler 4.1 web page:
– File Installation Notes (sqldev-install-windows-1969674.html) under ‘Windows 64-bit with JDK included’ mentiones ‘This download does not include the JDK’, but this package datamodeler-x64-4.1.0-881.zip *does* include the JDK :-))
– same file sqldev-install-windows-1969674.html is linked here as well twice, mentioning JDK 1.7, but 1.8 is the minimum requirement.
– file datamodeler-4.1.0-881-no-jre.zip is (should be) platform independant, therefore, you might name its entry not only ‘Windows 32-bit/64-bit’, but something ‘Windows / Linux 32-bit/64-bit’ or ‘Other Platforms’.
Best regards, Mark
Hi Jeff,
some comments on the SQL Developer 4.1 web page:
– file sqldev-install-windows-1969674.html mentiones JDK 1.7, but 1.8 is the minimum requirement.
– file Installation Notes (sqldev-install-linux-1969676.html) under Other Platforms points to the Linux RPM installation instructions, but SQL Dev. for Other Platforms is an universal zip file sqldeveloper-4.1.0.19.07-no-jre.zip). Installation instructions for that zip should also include Windows besides Linux as a platform :-))
– is ‘Command Line – SQLcl – Early Adopter’ (sqlcl-4.2.0.15.121.1046-no-jre.zip) really still early adopter or final?
Best regards, Mark
Crikey…thanks for the heads-up.
I fixed it 🙂
>>is ‘Command Line – SQLcl – Early Adopter’ (sqlcl-4.2.0.15.121.1046-no-jre.zip)
As advertised – still in Early Adopter mode.
My Win7 box flaked out last week. A running of checkdisk appears to have brought it back, but now SQLdev 4.1 will not show my connections, so I cannot connect to the database to do my work so I can make money so I can buy my kid the GI Joe with the kung-fu grip.
Jeff, what do I need to do to get my connections to display again?
your connections panel is empty or your connections panel won’t show?
In either case, find your system4.1 directory and rename the connections.xml file. If you have an older copy of sqldev laying around, export your connections from there and import them back to save a ton of typing
The problem is that the connections panel will not show.
View->Connections-> nothing happens.
I exported the connections from another install, but I cannot see how to import them into the 4.1 install that will not show my connections.
rename your system4.1 directory
restart sqldev
then import your connections
next time you get stuck, just call me!
hi,
i use visual studio 2010 for develop my program web and my data base is oracle..
i can’t insert persian data to my data base…when i insert persian data, in gridview and in my database it shows mark ?????.
i set NLS_LANG (AMERICAN_AMERICA.ar8mswin1256).
now,what i must to do?
thanks.
No idea.
Your problem is with your Visual Studio application? The first thing you need to figure out is if your persian data is actually in the database as you would expect it.
You can test this by just querying it with SQL Developer. If your editor display font is set to one that supports your characters, it should show as expected – Java and Unicode work REALLY well together.
I cannot for the life of me figure out how to alter the properties of more than one object at a time. If I select multiple objects in a model, then right click and select ‘propterties’, only the dialog box for one object appears.
Ideally, I could do this in the browser. For example, within the browser, select all of the relations in a model and change the properties of all those relations from identifying to non-identifying.
I can only seem to do it one-by-one.
Please help!
This post might give you some relief. Let me know if you’re still struggling, we might need to come up with a better answer.