Oracle provides a wide range of clear and helpful documentation on its products and you will be using the Getting Started with Oracle SQL Developer 3.0 tutorial here. It is part of a series of tutorials called Oracle by Example (OBE).
You can find the tutorial using the link at the end of this page, but before you start, please note the following points:
- Most of the steps in the Prerequisites section have been completed, but you should download the files provided into your C:\sqldev3.0 folder.
- In step 5 of the Creating a Database Connection section, you should use the following details:
XE stands for Express Edition. By convention, the connection name is made up of the username and the system id (SID).
- PL/SQL will not be covered in this module, so you can stop the tutorial when you get to that section
There is just one configuration setting that may cause problems when you try to run complicated scripts using SQL Developer. To make the change, choose Preferences... from the Tools menu. Change the value of PLScope identifiers to None as shown below.
In any relational database system there are some special user accounts which can perform administrative tasks. In Oracle, there are two of these create by default upon installation. Their usernames are SYSTEM and SYS. You will be using the SYSTEM account in later tutorials and in your coursework. For now though, you are using an ordinary user account whose username is HR to practise working with SQL and to develop some familiarity with SQL Developer.
User accounts may own tables (this is the case with HR) or they may have access to tables that are owned by other users. You will see more complicated situations like this later in the module. In this exercise you are only concerned with the tables owned by HR.
Please click on the link below which leads to a getting started tutorial from Oracle and work though the first six sections. Stop when you get to Creating Reports.