Search This Blog

Thursday, August 29, 2013

Different ways to login to the Database



1.
$sqlplus //from OS Prompt
enter username:
enter password:

SQL>show user //from SQL Prompt, shows the user currently 

2.
$sqlplus hr //from OS prompt logs into the user asking for password
Enter password

3.
$sqlplus hr/password@orcl //from OS prompt using the user name and pasword along with the database you want to login