CONNECT
The CONNECT command is used to change your database connection, log in as a different user, or to connect to the database in an administrative mode. Chapter 2 describes CONNECT for normal users. Chapter 10 describes the administrative options.
CONN[ECT] [username
[/password
][@connect
]|/|] [AS {SYSOPER|SYSDBA}]|[INTERNAL]
where:
- CONN[ECT]
May be abbreviated CONN.
- username
Is your database username.
- password
Is your database password.
- connect
Is the connect string, or host string, telling SQL*Plus the database to which you want to connect.
- /
Use a forward slash instead of your username, password, and connect string when you want to connect to a local database using operating-system authentication.
- AS
Tells SQL*Plus you are connecting in an administrative role.
- SYSOPER
Tells SQL*Plus you are connecting as an operator.
- SYSDBA
Tells SQL*Plus you are connecting as a database administrator.
- INTERNAL
Tells SQL*Plus you want to connect internally.
Get Oracle SQL*Plus: The Definitive Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.