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.
To log into SQL Developer, double click on the menu option or SQL Developer icon.
The splash screen will then display while the program loads.
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.
Choose your connection from the list on the left "Connections" tab of the screen and log in using the HR and relevant password.
To log into SQL*Plus, enter the following at an OS command prompt:
Substitute password with the correct HR password above. Note that queries need to be ended with a semi-colon or a forward-slash.