Development Tools

There are various tools that you can use to develop with SQL and PL/SQL, and to manage database objects.

Oracle Database XE has a browser-based user interface for administering database objects, running SQL statements, PL/SQL code, building Web-based applications, and more. The starting point for this interface is the Database Home Page. See "Logging in to the Database Home Page".

You can also use SQL Command Line (SQL*Plus) to enter SQL statements and PL/SQL code. To use SQL Command Line, see Using SQL Command Line.

Logging in to the Database Home Page

To log in to the Database Home Page:

Access the Database Home Page.

The page can be accessed from your graphical desktop or pointing your Web browser to a specific URL. See "Accessing the Database Home Page" in Oracle Database Express Edition 2 Day DBA Guide.

To view the database objects or run the examples discussed in this guide, log in to the Database Home Page as the user HR. In the Username field enter HR and in the Password field enter your password for the HR user account, then click the Login button. See "Sample HR Account".

Note:

If the HR user account is locked, you need to log in as a user with administrator privileges and unlock the account. When unlocking the account, ensure the HR user has both CONNECT and RESOURCE roles enabled. See "Locking and Unlocking User Accounts" in Oracle Database Express Edition 2 Day DBA Guide.

On the Database Home Page, click the icon for the specific tool that you want to use. There are icons for Administration, Application Builder, Object Browser, SQL, and Utilities when you log in as the HR user.

The Database Home Page includes links to the License Agreement, Getting Started, Learn More, Documentation, Forum Registration, Discussion Forum, and Product Page. The Usage Monitor on the page provides information about the storage and memory use, number of sessions and users, and log archiving status.