How to install sqldeveloper on Linuxmint 14/Ubuntu12.10

By
Roy s

Oracle SQL Developer is an Integrated development environment (IDE) for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.

Oracle SQL Developer supports Oracle products and a variety of third-party plugins which users may deploy to connect to non-Oracle databases. Oracle SQL Developer works with IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Sybase Adaptive Server, and Teradata databases.

Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for PL/SQL.

1- Download  Sqldeveloper   from Oracle  Website

[email protected] ~/Downloads $ ls
 sqldeveloper-3.2.20.09.87-no-jre.zip

 2-  Check  your installed Java version using the command:

[email protected] ~/Downloads $ java   -version
Output
java version "1.7.0_07"
 OpenJDK Runtime Environment (IcedTea7 2.3.2) (7u7-2.3.2a-1ubuntu1)
 OpenJDK 64-Bit Server VM (build 23.2-b09, mixed mode)
 [email protected] ~/Downloads $

3-  extract  SQldeveloper

Cd the directory where you downloaded sqldeveloper and extract the file:

unzip Sqldeveloper .x.x.zip
cd   sqldeveloper

Now make the script executable:

chmod +x  sqldeveloper.sh

4- Now run the  sqldeveloper  script

./sqldeveloper.sh
Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.Type the full pathname of a J2SE installation (or Ctrl-C to quit),
the path will be stored in ~/.sqldeveloper/jdk

Please put  your  Java PATH

4- connect  and  enjoy SQL Developer:)