Password and connection for Scott, system, and sys in Oracle

Scott's password is: Tiger

The system password is Manager.

Sys password: change_on_install

 

If you have installed oralce9i, note the following when using system or sys for connection:

If the current connection is system/super Administrator (sys): Write as sysdba at the end of the connection. Log on as a system administrator.

For example, Conn system/manager as sysdba, Conn sys/change_on_install as sysdba.

 

TIPS:

1. If you want to know that the current user is:

Show user; displays the user currently being connected

You can also use Select User from dual; the effect is the same.

 

2. If multiple tables exist in a database, you can run the following command to obtain all the table names in the database:

Select * From tab; if you log on with different users, the data in the table you see is also different.

 

3. The most commonly used in development is to view the structure of a table. For example, you can use the DESC table name to view the complete structure of a table.

 

4. You can enter a "/" in sqlplusw to repeat the operation of the previous statement.