What You See Is What You Get Element

Oracle SQL Developer FAQ

 

Date: December 2013

SQL Developer on OTN | Downloads | Documentation | Exchange | Forum


The following is a list of Frequently Asked Questions:

 

What platforms are supported?

    • Oracle SQL Developer 4.0 is available for Windows XP , Vista, Windows 7 and 8 and Windows Server 2008/2012, Linux or Mac OS X. (See full Certification)

What JDK is supported?

    • Oracle SQL Developer 4.0 release supports java version 1.7 and above.
    • 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, not the java.exe.  For example C:\Program Files\Java\jdk1.7.0_25.

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.

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 11g Release 2. To use JDBC Thick Driver, you need to install an 11g Release 2 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.0, Third Party Extensions written for previous versions of SQL Developer will not work. The Third Party vendor will need to update extension for OSGI framework. Instructions can be found here.

Third Party Databases

    • SQL Developer supports IBM DB2 UDB LUW and iSeries, Microsoft SQL Server and Microsoft Access, 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. Read this Getting Started document to show you how.
    • You can also download and include the third-party database drivers manually. See the existing documentation for that on OTN. 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 (11.2.2.0.0 or greater) or TimesTen 11.2.1 (11.2.1.4.0 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/ttenv.sh 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. If a separate 1.8 client is used, SQL Developer will not work with it.

How to set up CVS

  • If you use a local repository. You must use an external CVS client and set the CVS versioning properties to point to the external client.

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.

 

Left Curve
Popular Downloads
Right Curve
Untitled Document