| Lesson 4 || Logging into a database |
| Objective || Log into a database with SQL*Plus. |
Logging into an Oracle Database
The easiest way to start looking at data in your Oracle database is to use the built-in tool called SQL*Plus.
Uses of SQL*Plus
SQL*Plus gives you a convenient interface with a database in which you can:
- Create database objects such as tables, indexes, and constraints
- Create users and roles
- Grant or revoke privileges of users and roles
- Edit and execute queries
- Adjust output settings to produce simple reports
- Edit and execute PL/SQL blocks
- Insert, update, and delete data in tables
- Spool output to a file
- Read and write files containing SQL or PL/SQL scripts
You can reach SQL*Plus from the client or the server side, as shown in a previous lesson. Both client and server versions of SQL*Plus have the same look and feel.
This tool is available to you in both command line
mode and window mode.
During this course, you will use the window mode for SQL*Plus because it is quickly becoming the preferred mode among database developers.
Log into SQL*Plus
Here is a demonstration of how to log into SQL*Plus.
Log into SQL Plus
In the next lesson, we begin exploring the extensions to SQL that Oracle has added for enhancing the SQL standard language.