Sqlplus login Database

1. Directly press sqlplus and press enter to start SQL * Plus. Entering the user and password will allow the user to log on to the default database.

C: \ Documents ents and Settings \ Administrator> sqlplus

SQL * Plus: Release 9.2.0.1.0-production on

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

Enter the User Name:

2. sqlplus user/password @ SERVICE_NAME will be connected to the specified database

C: \ Documents ents and Settings \ Administrator> sqlplus dbusername/password @ SERVICE_NAME
SQL * Plus: Release 9.2.0.1.0-production on

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

Connect:
Oracle9i Enterprise Edition Release 9.2.0.1.0-Production
With the partitioning, OLAP and Oracle Data Mining options
Jserver release 9.2.0.1.0-Production

SQL>

3. If you press sqlplus/nolog, SQL * Plus is enabled, but you do not log on to the Oracle database. Then you need to use the connect command to connect to Oracle

C: \ Documents ents and Settings \ Administrator> sqlplus/nolog

SQL * Plus: Release 9.2.0.1.0-production on

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.

SQL> connect dbusername/password @ SERVICE_NAME
Connected.
SQL>