Logging into SQL*Plus in a command line Environment
If you prefer to use a command line environment, or if that is your only option, you can start up SQL*Plus in the command line mode.
On Windows, start up a command line window (MS-DOS prompt). On UNIX, start up a terminal window or get to the dollar($) prompt. Then follow these steps:
Enter user-name: PETSTORE
sqlplus and press Enter. SQL*Plus starts up and prompts you for a valid username:
- Type a username and press Enter. The username for the sample user in this course is
PETSTORE. If you do not know a username, use the default username,
SCOTT. SQL*Plus prompts you for a password:
- Type the password for the username that you typed and press Enter. The default username
SCOTT has the password
TIGER. The password for the sample user in this course is
You will not see the password when you type it on the screen. SQL*Plus logs you into the database and signals that it is ready to accept your commands by displaying the SQL prompt:
SQL> SELECT TABLE_NAME 2 FROM USER_TABLES 3 ORDER BY TABLE_NAME 4 SQL>
- Type in one or more lines of a query (or other SQL command). When done, press Enter until you see the
SQL> / SQL*Plus executes the query and displays the results on the screen. Then another prompt is displayed signaling that SQL*Plus is ready for more input. TABLE_NAME ------------------------------ CUSTOMER CUSTOMER_SALE
PET_CARE_LOG PRODUCT SALE_ITEM SQL>
- Type a forward slash (/) and press Enter to execute the query.
To exit, type EXIT and press Enter. SQL*Plus closes and returns you to your operating system.