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
shellhoop admin create conn my-oracle-db -a <agent> \ -e SQLCL_URI=<uri> \ -e TERM=<term> \ -- sqlcl
Then it's possible to run queries into a oracle database
shellhoop exec my-oracle-db -i 'SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL'