Name

CONNECT

Synopsis

CONN[ECT] [username[/password][@connect] |
    / ] [AS {SYSOPER | SYSDBA}] | [INTERNAL]

The CONNECT command changes your database connection, logs in as a different user, or connects to the database in an administrative mode. For example:

CONNECT SYSTEM/MANAGER@EMPDB
CONNECT /
CONNECT SYSTEM/MANAGER AS SYSDBA

Parameters

username

Your database username.

password

Your database password.

connect

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. Beginning with Oracle9i, this is no longer a valid option.

Get Oracle SQL Plus Pocket Reference, 2nd Edition 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.

Start your free trial