Monday, 12 January 2015

Creating Connection in SQL Developer

A connection is a SQL Developer object that specifies the necessary information for connecting to a specific database as a specific user of that database. You must have at least one database connection to use SQL Developer.

1.       To create a new database connection, right-click the Connections node  and select New Connection (I named the new connection: Learn SQL (see tag number 1). Fill in the connection form as shown in the following figure.
2.       Enter hr for both username and password. HR is a sample schema, provided with XE database, containing tables and other objects. You’ll use the data held in this schema to perform all the exercises provided in this book.
3.       After completing the form, click the Test button. The Success message in the status section should come up, indicating that you are ready to proceed further.
4.       Click the Save button to save the connection. The new connection should appear in the left pane of the form.
5.       Click Cancel to dismiss the connection form.
6.       Click on the SQL Worksheet icon and select Learn SQL from the provided list. This will open a worksheet for the selected connection, where you will enter your SQL statements to interact with the corresponding database.
































No comments:

Post a Comment