Customizing Your SQL Prompt- Configuring an Efficient Environment
DBAs frequently use SQL*Plus to perform daily administrative tasks. Often, you’ll work on servers that contain multiple databases. Obviously, each database contains multiple user accounts. When connected to a database, you can run the following commands to verify information such as your username, database connection, and hostname: SQL> show user; SQL> select name from v$database; […]