2.4.5 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