Shortcuts to starting SQL * Plus

Although beginning SQL* Plus, the username along with the password and the database alias (if needed) can be produced. The username and the password must be separated through a / (slash). For example let’s consider a user who known as SCOTT and the password known as TIGER.

If the user is connected to the personal database the SQL * Plus can be begin through giving,

PLUS80W SCOTT/TIGER    (or)    SQLPLUS SCOTT/TIGER

If the user is connected to a network the SQL * Plus can be begin through giving

PLUS80W SCOTT/TIGER@ORACLE

After this, the SQL prompt appears from whereas the commands can be executed and entered.