2.4.4 Oracle Connection Type
Connect to a database using Oracle Relational Database Management System.
The connection spec parameter has the following form:
<username>[/<password>][@<url>][as <role>][edition= <edition>]
where
-
<username> may be <proxyuser>[<username>] if a proxy user is required. Note that the brackets around user name are required syntax.
-
The <url> can take either of the following forms:
//<host>:<port>/<service> <host>:<port>/<service>
or it may be a TNS name or an LDAP specification.
Options
Option | Description |
---|---|
-oracle, o | Specifies an Oracle connection type. |
-user, u | Specifies the user name. This is an alternative to providing it in the connection spec parameter. |
-password, pw | Specifies the password. This is an alternative to providing it in the connection spec parameter. |
-url | Specifies the URL. This is an alternative to providing it in the connection spec parameter. |
-role, r | Specifies the database role. This is an alternative to providing it in the connection spec parameter. |
-edition, ed | Specifies the Oracle database edition. This is an alternative to providing it in the connection spec parameter. |
-verbose, v | Requests output of diagnostic information about the connection. |
Parameters
Parameter | Description |
---|---|
<connectionspec> | Provides the connection specification for the target database. |
Example
To connect using EZCONNECT:
SQL> CONNECT myuser/passwd@myhost:1521/myservice