No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions
Oracle SQL Developer

Oracle SQL Developer FAQ

Date: April 2019

    Frequently Asked Questions

    Open all Close all
  • What platforms are supported?
    • Oracle SQL Developer 4.1 is available for Windows 7, 8, 8.1 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification)
  • What JDK is supported?
    • Oracle SQL Developer 4.1 release requires Java version 1.8.
    • If SQL Developer cannot find a local JDK, you will be prompted to enter the location path for the JDK. Note that the prompt wants only the folder location, not the java.exe. For example C:\Program Files\Java\jdk1.8.0_40.
  • Installation of a new version of SQL Developer
    • All new releases of SQL Developer require a full installation. Download and unzip the file into an empty folder.
  • Migrating settings from previous releases
    • After you have installed the product you are asked if you want to migrate from a previous release. This migrates previously set preferences and connections.
  • Migrating Passwords
    • Passwords are migrated when installing a new version on the same machine. When porting SQL Developer to a new machine, passwords will not be migrated unless protected with a pass phrase..
  • Location of User Defined Reports, Snippets and SQL History
    • User-defined reports, SQL History and user-defined snippets files are located in the \Documents and Settings\<your_user>\Application Data\SQL Developer folder. These are also migrated.
  • Migrating Folders created in a previous release
    • If you created folders in release 1.5.1 or above, these are automatically included in the migration. If you choose not to migrate your settings between releases, then you can import your old connections. This does not include folders.
  • What JDBC Drivers are shipped with product
    • The JDBC drivers shipped are Oracle Database 12c Release 2, specifically. To use JDBC Thick Driver, you need to install an 12c client.
  • Settings for the Debug Log Window
    • This is now set off by default. If you want to see the SQL Developer debug log window information by default, then replace the line "IncludeConfFile sqldeveloper-debug.conf " in the sqldeveloper.conf file located in sqldeveloper\sqldeveloper\bin\sqldeveloper.conf .
    • To start up the debug log window in the product while you are working, enter "setloglevel oracle.dbtools ALL" in the SQL Worksheet. This will stay on while you are working, but won't reopen the log window if you stop and restart the product.
  • How to add/update aThird Party Extension
    • In SQL Developer 4.1, Third Party Extensions written for versions prior to version 4.0 of SQL Developer will not work. The Third Party vendor will need to update extension for OSGI framework.
  • Third Party Databases
    • SQL Developer supports IBM DB2 UDB LUW and iSeries, Microsoft SQL Server, MySQL, Sybase Adaptive Server and Teradata. See Supported Platforms for details on all third party database releases supported.
    • You will not see any third party tabs in the connections dialog until you have installed the drivers.
    • You can also download and include the third-party database drivers manually. Alternatively you can use Check for Updates to setup these drivers.
    • Do not use the latest MySQL driver 5.1. Use the 5.0.x drivers for MySQL.
  • Connecting to TimesTen and In-Memory Database Cache in SQL Developer
    • Before you can use SQL Developer to connect to TimesTen:
      • Install TimesTen 11.2.2 ( or greater) or TimesTen 11.2.1 ( or greater) of the server or client on the same machine as SQL Developer.
      • On Linux systems, source the shell script TimesTen_install_dir/bin/ttenv.csh or TimesTen_install_dir/bin/ to set up the TimesTen environment variables before launching SQL Developer. On Windows, use the TimesTen_install_dir\bin\ttenv.bat script.
      • Make sure the CLASSPATH environment variable is pointing to the TimesTen JDBC driver (TimesTen_install_dir/lib/ttjdbc6.jar).
      • Read these more detailed release notes on TimesTen.
  • Table filters on the tables node
    • The list of tables displayed includes generated tables, AQ's and others not previously included in the list. By default there is a filter on the Tables node to exclude objects from the recycle bin.
  • Code Templates/Snippets

    Code insight contains a comprehensive database of code fragments fetched from SQL and PL/SQL reference manuals. Upon a user entering a keyword prefix in SQL Developer, code insight brings up the list of code fragments syntactically valid within the user source context. Each list entry is amended with a button referring to the documentation web page. In a similar venue, SQL Developer suggests query fragments fetched from SQL history.

  • What Version Control Systems are supported?
    • Subversion and GIT are installed by default with SQL Developer 4.0. To install CVS, Perforce and Serena Dimensions, please use Help > Check for Updates.
  • Supported versions of Subversion
    • We support 1.7 and 1.8.
  • Font Settings
    • The font setting for the Code Editor now also increases the font size for the script output window and all data grids. This is in addition to increasing the font size for the SQL Worksheet and PL/SQL Code Editors. Select Tools | Preferences | Code Editor | Fonts and set the font size.