Sunday, 11 January 2015

Download and Install SQL Developer

SQL Developer is a graphical user interface (GUI) tool that Oracle Corporation supplies to query databases, browse objects, execute reports, and run scripts. It supports Windows, Linux, and Mac OSX. SQL Developer is a non-licensed (free) product. Besides Oracle database, it can be used to connect and access third-party (non-Oracle) databases, such as MySQL, Microsoft SQL Server, Sybase Adaptive Server, Microsoft Access, and IBM DB2. Note that SQL Developer doesn't need any installer so it also does not create any registry entries. Similarly, deleting the SQL Developer directory removes it from your system and you do not have to run any uninstaller for it.

1.       You can download it from the following URL.
2.       Click the download link defined next to the prompt: SQL Developer requires JDK 7 or above.
3.       Save and extract the zip file to a directory of your choice..
4.      Double click sqldeveloper.exe file from the extracted folder to start SQL Developer.


NOTE
One of the first tasks that you may be prompted to do when you start SQL Developer for the first time is to locate the Java Development Kit (JDK). SQL Developer requires JDK 7 or above. If you selected the option to download SQL Developer with the JDK, then java.exe will be included in the jdk sub-folder where you extracted the zip file. If you couldn't locate the jdk sub-folder then you have to download and run the jdk software (jdk-7u71-windows-i586.exe) from: http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html


SQL Developer Interface





The above figure illustrates the interface of SQL Developer, marked with some important sections of this useful software that you’ll use in this book.

1.       Learn SQL: The connection pane displays all connections you’ve created to connect to different databases. In the next section you’ll create a connection named Learn SQL to connect to the Oracle XE database, that you just installed.
2.       Tables: As a beginner you’ll interact with database tables in this book to learn SQL. Once you connect to your database, you can expand this node to browse all the tables in the database. You can even see structures of tables and the data stored in each table through this node.
3.       Worksheet: This is the pane which you’ll use throughout the exercises presented in this book. Here you’ll enter SQL statements to interact with your database.
4.       Run Statement: You click this button to execute your SQL statements.
5.      Query Result: The result of the executed SQL statement that you enter in the Worksheet will appear in this section. 







No comments:

Post a Comment