Connecting to Oracle

Contact Us or call 1-877-932-8228
Connecting to Oracle

Connecting to Oracle

As you know from working with Oracle SQL when you interact with an Oracle database, you do so with a given identity (Oracle user). This user can take certain actions within a subset of the database, some of which contains objects that the user owns (schema). The Oracle HR Schema (Human Resources data for a fictional company) will be used for this course.

SQL*Developer

To log into SQL Developer, double click on the menu option or SQL Developer icon.

Image of SQL Developer Icon

The splash screen will then display while the program loads.

Image of SQL Developer Icon

Configure your connection (if needed). To configure a new connection, right click on "Connections" in the leftmost tab, choose New Connection, enter the connection information, and test the connection and make any needed corrections.

Image of SQL Developer Icon

Choose your connection from the list on the left "Connections" tab of the screen and log in using the HR and relevant password.

SQL*Plus

To log into SQL*Plus, enter the following at an OS command prompt:

sqlplus <HR>/<password>@<database>

Substitute password with the correct HR password above. Note that queries need to be ended with a semi-colon or a forward-slash.

Next