Hi everyone,
I had successfully connected to an Oracle database wi the the following commands:
library(ROracle)
drv <- dbdriver("Oracle")
connect.string <- paste("(DESCRIPTION=","(ADDRESS=(PROTOCOL=tcp)(HOST=",")(PORT=",port,"))","(CONNECT_DATA=(SERVICE_NAME=",svc,")))",sep="")
con <- dbConnect(drv, username=user, password=pass, dbname=connect.string)
The evaluation of the variable con shows zero as result respectively for the outputs 'Results processed' and 'Open results'
However my tables of interest are stored in and oracle system folder 'Other Users' (see which includes several schema objects which shelters the tables and the latter are located in appropriate structure like views
PLEASE HOW MAY I FORMULATE MY RORACLE REQUEST TO SELECT FOR EXAMPLE THE COLUMN MEANT_TEMP OF THE TABLE DAILY_CLIMATE IN THE VIEW DAILY_CLIMATE OF SCHEMA OBSERVATION IN THE SYSTEM STRUCTURE 'OTHER USERS'?
MANY THANKS FOR A HELP