Oracle Command (i): Oracle login Command

1. Run Sqlplus tool

C:\users\wd-pc>sqlplus

2. Go directly to the Sqlplus command prompt

C:\users\wd-pc>sqlplus/nolog

3. Connect as OS Identity

C:\users\wd-pc>sqlplus/as SYSDBA or

Sql>connect/as SYSDBA

4, Normal User login

C:\users\wd-pc>sqlplus scott/123456 or

Sql>connect scott/123456 or

Sql>connect Scott/[email protected]

5. Log in as Administrator

C:\users\wd-pc>sqlplus sys/123456 as SYSDBA or

Sql>connect sys/123456 as Sysdba

6. Switch users

Sql>conn hr/123456

　　NOTE: Conn with connect

7. Exit

Exit

Oracle Command (i): Oracle login Command