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
Pirat9@pirat9-VirtualBox ~/Downloads $ ls sqldeveloper-3.2.20.09.87-no-jre.zip
2- Check your installed Java version using the command:
pirat9@pirat9-VirtualBox ~/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)
pirat9@pirat9-VirtualBox ~/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:)
