Oracle

Execute queries to oracle instances with sqlcl.

Type: command-line

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.

Then it's possible to run queries into a oracle database

shell
hoop exec my-oracle-db -i 'SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL'