Ask A Question

4.5+ million 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.

  1. 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.
  2. 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.
  3. 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!

4,866 Comments

  1. Stuart Higgins Reply

    Hi Jeff, Great site and tweets! I need to connect to Oracle 8.1.7. Which is the latest version of SQL Developer that will work with it ? I would love to use the latest version if there is a way to do that. Thank you.

    • thatjeffsmith

      Not much we can do for 8i. 11g is about as far back as we support today.

      You can try with version 1.5 maybe, but even that might not work.

  2. Hi Jeff,

    I often have the challange to identify all appearances of a database link. When I do a search, I get no results for synonyms. Should I be able to find database links used in synonyms, or is that not possible with the search?

    BR
    Stefan

    • thatjeffsmith

      appearances of a db link – why aren’t you searching the SOURCE area for occurrences of a ‘@’ ?

  3. Hello, I followed blog ( https://developer.oracle.com/databases/building-jet-crud-apps-odb12c ) to invoke rest web service but am getting CORS error ( refer below). Have installed ORDS within sql developer ( version 18.1.0.095) and rest service works and returns json output. I tried setting “Origins Allowed” at module level but still it gives gives the same error.

    Can you please guide as how to setup the access control across domains in ORDS.

    Thanks in advance.

    Error :

    Access to XMLHttpRequest at ‘http://localhost:8080/ords/apps/hr/department/555’ from origin ‘http://localhost:8383’ has been blocked by CORS policy: Response to preflight request doesn’t pass access control check: No ‘Access-Control-Allow-Origin’ header is present on the requested resource.

  4. I am new about SQL Dv Data Modeling; version 18.4 of Dmodeler needs “msvcr120.dll” under bin directory.
    JDK is already installed and its version 11.2. Is there anything that mismatches?

    • thatjeffsmith

      wow, i haven’t seen that error in a LOOOOONG time

      i think the easiest fix is to just search your pc for that dll file, and copy it to your sqldeveloper\bin directory

  5. Hi Jeff,
    I use many connections in Oracle SQL developer (100+, various databases, schemas). I named the connections to have them sorted and well organized to quickly find out right one.
    But it is useless when I try to open a new SQL worksheet by pressing Alt-F10 (or change a connection in current worksheet in right-upper dropdown list), becouse connections in ‘Select connection’ window are sorted by last used timestamp.
    Is it a way how to change the behaviour?

    And one more proposal – would be good to have option to control text and background color in the dropdown list of connections (or check box, apply color setting for frame only, not for connection dropdown list). Color frame around worksheet is nice, but some combinations of colors are not readable in dropdown list.

    Thanks a lot
    Martin

    • thatjeffsmith

      No sorry there’s no way to make that change today.

      Since you have your organization already configured the way you want connection wise, why not open a worksheet from your connections panel instead?

  6. Hi Jeff!

    I’m a keyboard shortcuts enthusiast!
    I try to use as much as I can Oracle SQL Developer with the keyboard.

    I know how to open a new window with a new connection (Alt + F10).

    But there is an action that I did not find the shortcut. How do I change the connection of my current window?

  7. Cléber Macieski Reply

    Hi mr. Jeff, I searched the web and didn’t find so: is there a way to customize a default tab in the ‘open declaration/describe’ at SQLDeveloper 18.4 for Windows 10?
    I would not like to to create an xml extension Constraint2 tab with my layout, so I will be happy to know like to override the default layout.
    Thank you.

    • thatjeffsmith

      I don’t believe so…the best you could do is add a new page to an existing object viewer, then open that object, and tab to your custom page.

  8. Hi Jeff

    All SQLcl 18.4 features seem to be working pretty well on cygwin except one : TAB Completion
    I’ve tried with both login shell (bash and ksh) and still doesn’t work

    Similar thread has already been raised : https://community.oracle.com/thread/4085611 but with no relevant answers asof now.
    I think this is related to cygwin env setting knowing MobaXterm which is technically very close to Cygwin+Putty.

    Under my shell Tab competion works perfectly fine (whether using bash or korn shell) so this is rather odd

    Here is my configuration ( with bash) :
    # sqlcl

    Launching /Appli/sqlcl_18.4/bin/sql SYS/********@C1N00002 as SYSDBA …

    SQLcl : version 18.4 Production sur jeu. mars 21 11:29:50 2019

    Copyright (c) 1982, 2019, Oracle. Tous droits réservés.

    Connecté à :
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Advanced Analytics and Real Application Testing options

    SQL> show version
    show version
    Version d’Oracle SQLDeveloper Command-Line (SQLcl) : 18.4.0.0
    SQL>
    # uname -a
    CYGWIN_NT-6.1 S0415796 2.10.0(0.325/5/3) 2018-05-18 20:52 i686 GNU/Linux
    # bash –version | egrep ^GNU
    GNU bash, version 4.1.17(0)-release (i686-pc-cygwin)
    # env | egrep -i term
    TERM=xterm-256color
    ORACLE_TERMINAL=/Appli/oracle/product/12.2.0/client_1/guicommon2/tk21/admin/terminal/US
    WINPATH=C:\Program Files\Common Files\Oracle\Java\javapath;C:\Appli\oracle\product\12.2.0\client_1\bin;C:\Appli\MobaXtermRoot\bin;C:\oracle\ORA112\bin;C:\oracle\ORA102\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\1E\NomadBranch\;C:\Program Files\GTK2-Runtime\bin
    HOME=/home/mobaxterm
    LOG=/home/mobaxterm/LOG
    TERMNUM=3
    HISTFILE=/home/mobaxterm/.sh_E0254079
    #set -o
    Current option settings
    allexport off keyword off notify off trackall off
    bgnice off login off nounset off utf8-mode off
    braceexpand on markdirs off physical off verbose off
    emacs off monitor on pipefail off vi on
    errexit off noclobber off posix off vi-esccomplete off
    gmacs off noexec off privileged off vi-tabcomplete on
    ignoreeof off noglob off restricted off viraw off
    inherit-xtrace on nohup on sh off xtrace off
    interactive on nolog off stdin on

    Thanks by advance !

    • thatjeffsmith

      I don’t use cygwin or MobaXterm…my buddy Tim (aka oraclebase) says he’s running MobaXterm and tab completion in sqlcl 18.4 is working as expected there.

  9. hi Jeff, I downloaded and installed SQLDeveloper 18.4, but I can’t connect using my Oracle wallet. I have a local wallet (not Cloud Wallet).

    Currently I’m using SQL Developer 3.x and the connection I use for my DBs is: jdbc:oracle:oci:/@dbname.

    It connects flawlessly. But I can’t get SQLDeveloper 18.4 to do the same. I get this error:

    “An error was encountered performing the requested operation:no ocijdbc18 in java.library.path”

    I downloaded the ODBC drivers from Oracle but no matter where I place them, I keep getting the same error.
    I only have one client folder.

    I tried enabling Oracle OCI on it, but was not able to (I have the classic client, not instant client).

    So I’m puzzled on how SQL Developer 3.x can connect real quick using the wallet, but SQLDeveloper 18.4 can’t. By the way, SQL Developer 3.x does not have the Use OCI/Thick Driver checkbox checked in the Database Advanced settings. I tried both with SQLDeveloper 18.4 and none of it has worked.

    Let me know if you have any advice.

    thanks!

    • thatjeffsmith

      the error is saying we can’t find a compatible oracle client for the 18c jdbc driver we’re using

      you need to configure the oracle home to point to a valid 18c oracle client home or instant client

      19.1 MIGHT allow you to setup a jdbc-THIN connection using a wallet too – so stay tuned

  10. In SQL Developer when I click on File – Open, in the Location field I want to change what is defaulting in that box. Where in the setup can that default be changed?

  11. In SQL Developer when I click on File – Open in the Location box it defaults a directory. I would like to change that default. Where is that set?

    • thatjeffsmith

      Based on your OS user temp directory the first time you do this. But the 2nd time you do it, it’ll start where you left off last time, the MRU directory.

      And then down the left hand side, you’ll have a historical listing of previously used directories as quick short cuts.

Write A Comment