getDataOracle: Query Data ILOSTAT

Description Usage Arguments Details Author(s) Examples

Description

Query data from ILOSTAT Oracle database

Usage

1
getDataOracle(data_query, con)

Arguments

data_query

SQL character string for select in table Data and Note, faster if split in 2: QTABLE and VALUE, check example.

Connect

list of 4 characters string to initialiyse JDBC connection: list( drv = JDBCDriver , a DBI driver connection, dns = 'jdbc_oracle_thin_client//my_localhost:my_port/my_service_name', user = 'my_user_name', pwd = 'my_password')

Details

Helper function to efficiently query data from ILOSTAT Oracle database.

Author(s)

ILO bescond

Examples

1
2
################################## 
 head(res)					

dbescond/Ariane documentation built on May 15, 2019, 1:20 a.m.