getDataOracle: Query Data ILOSTAT

In dbescond/Ariane: Ariane package internal functions for ILO Statistics department

Description

Query data from ILOSTAT Oracle database

Usage

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

################################## 
 head(res)					

dbescond/Ariane documentation built on Dec. 10, 2019, 10:01 a.m.