logo
Execute queries to oracle instances with sqlcl.
Type: command-line

Configuration

Name
Required
Description
SQLCL_URI
yes
The connect identifier. Example: myusername/mypassword@Host/ORCL
TERM
yes
The name of terminal setting
In order to configure this type, it's necessary to create the target directly from the API
shell
hoop admin create conn my-oracle-db -a <agent> \ -e SQLCL_URI=<uri> \ -e TERM=<term> \ -- sqlcl
To add more options to the command line, update the command option of the connection.

Examples

Then it's possible to run queries into a oracle database
shell
hoop exec my-oracle-db -i 'SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL'