Queries

yaml
type: "io.kestra.plugin.jdbc.oracle.Queries"

Examples

yaml
id: oracle_query
namespace: company.team

tasks:
  - id: select
    type: io.kestra.plugin.jdbc.oracle.Queries
    url: jdbc:oracle:thin:@localhost:49161:XE
    username: oracle_user
    password: oracle_password
    sql: select * from employee; select * from laptop;
    fetchType: FETCH

Properties

sql*string

url*string

afterSQLstring

fetchSizeintegerstring

Default10000

fetchTypestring

DefaultNONE

Possible Values

STOREFETCHFETCH_ONENONE

parametersobject

passwordstring

timeZoneIdstring

transactionbooleanstring

Defaulttrue

usernamestring

Outputs

outputsarray

Definitions

io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output

rowobject

rowsarray

SubTypeobject

sizeinteger

uristring

Formaturi

Metrics

fetch.sizecounter

Unitrows