works great on your mobile device too!

SQL Developer, Installation

<- SpecialTopics


The following covers the most essential steps to start using Oracle's SQL Developer on a Windows system.


  • From your DBA get the following:
    • Username and Password (ex: scott\tiger)
    • Hostname (ex: orahost01).
    • Database Service Name (ex: oradb).
    • Port Number (ex: 1521).
  • You must have the Microsoft Visual C++ Redistributable Package installed.
    Choose the file named vcredist_x64.exe.


  1. Create a C:\app directory (all Oracle software uses this as the base).
  2. Download the latest version to the C:\app directory.
    Select: Windows 64-bit with JDK n included
  3. Unzip the file. It will create a corresponding subdirecotry.
    Example: C:\app\sqldeveloper-\sqldeveloper
  4. From the ...\sqldeveloper sub-directory create a shortcut to the sqldeveloper.exe file on to your desktop.
  5. Double-click the desktop short-cut to start the application.

Initial Run

  • If prompted to Confirm Import Preferences select No.
  • On the top left, click the green plus (+) sign to create a connection.

Complete Essential Fields

Enter the values from your DBA for the items in blue.

  • Connection Name: <Enter a Descriptive>
  • Username: scott
  • Password: tiger
  • Select [x] Save Password.
  • Connection Type: Basic
  • Hostname: orahost01
  • Port: 1521
  • (x) Service Name: oradb
  • Press Test then Save after working.