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