April 2000
Intermediate to advanced
94 pages
1h 52m
English
CONNECT
CONN[ECT] [username[/password][@connect] |
/ ] [AS {SYSOPER | SYSDBA}] | [INTERNAL]The CONNECT command is used to change your database connection, log in as a different user, or connect to the database in an administrative mode. For example:
CONNECT SYSTEM/MANAGER@EMPDB CONNECT / CONNECT SYSTEM/MANAGER AS SYSDBA
Is your database username.
Is your database password.
Is the connect string or host string telling SQL*Plus the database to which you want to connect.
Allows you to 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.
Tells SQL*Plus you are connecting in an administrative role.
Tells SQL*Plus you are connecting as an operator.
Tells SQL*Plus you are connecting as a database administrator.
Tells SQL*Plus you want to connect internally.