|SQL*Plus User's Guide and Reference
Part Number A88827-02
Learning SQL*Plus Basics, 2 of 5
To begin using SQL*Plus, you must first understand how to start and leave SQL*Plus.
This example shows you how to start SQL*Plus. Follow the steps shown.
You should see one or more characters at the left side of the screen. This is the operating system's command prompt, which signals that the operating system is ready to accept a command. In this guide the operating system's prompt will be represented by a dollar sign ($). Your computer's operating system prompt may be different.
SQL*Plus displays its version number, the current date, and copyright information, and prompts you for your username (the text displayed on your system may differ slightly):
The process of entering your username and password is called logging in. SQL*Plus displays the version of Oracle to which you connected and the versions of available tools such as PL/SQL.
Next, SQL*Plus displays the SQL*Plus command prompt:
The command prompt indicates that SQL*Plus is ready to accept your commands. Throughout this guide, where you see the keyboard icon in the margin, it is prompting you to enter information at the command prompt line. Where you see the computer screen icon in the margin, it is showing you what you should expect to see displayed on your screen.If SQL*Plus does not start, you should see a message to help you correct the problem.
When you start SQL*Plus, you can enter your username and password, separated by a slash (/), following the command SQLPLUS. For example, if your username is HR and your password is HR, you can enter
and press Return. You can also arrange to log in to SQL*Plus automatically when you log on to your host operating system. See the Oracle installation and user's guide provided for your operating system for details.