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
plain texthoop admin conn create
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
plain texthoop exec my-oracle-db -i 'SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL'