OREST Connection Type

Connect to a database using REST. The connection spec parameter has the form:

<username>[/<password>][@<url>][as <role>][edition= <edition>]

The <url> can take the form:

http://<host>:<port>/ords/<schema>

Options

Option	Description
-orest, or	Specifies a connection type that uses REST.
-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 REST:

SQL> CONNECT myuser/passwd@http://myhost:9213/ords/myschema