Oracle Certification, Database Administration, SQL, Application, Programming Reference Books
Oracle SQL+: First glance

Start Up:

After setting up the environment for Oracle, at your unix prompt (i.e., prompt is >) type:
>  sqlplus

SQL*Plus: Release 3.3.2.0.0 - Production on Tue Sep 30 18:10:29 1997
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Then SQL+ asks for you username and password, type your RCS-username attached with @ora7 (i.e., [your RCS-id]@ora7 ) and your password, the one you are given.
Enter user-name:  [userid]@ora7
Enter password:  [your oracle password]
Connected to:
Oracle7 Server Release 7.2.2.3.0 - Production Release
PL/SQL Release 2.2.2.3.0 - Production
SQL>
You are now entering the application tool and ready to execute any ad hoc SQL command.

 

 


Changing your password:
You can use SQL+ to change your password in Oracle by At the SQL+prompt (SQL prompt is SQL>) type:
SQL>  ALTER USER [userid] IDENTIFIED BY [newpasswd];
User altered.
Please note that the [userid] here does NOT have @ora7 and the password is case-insensitive and is NOT cover by quote (').

Exit:
To exit, at the SQL+ prompt type:
SQL>  exit
Disconnected from Oracle7 Server Release 7.2.2.3.0 - Production Release
PL/SQL Release 2.2.2.3.0 - Production

Exit to :  Oracle Hints and Tips