[R] RODBC to query an Oracle table

[Prof Brian Ripley]

It's your R syntax that is faulty: Use "" (not ') to delimit the R string 
which contains single quotes for use by SQL.

On Mon, 28 Jul 2008, Megan J Bellamy wrote:

> Hello all,
>
> I am having trouble running a count function in R using RODBC to query a table I created in Oracle. It may very well be that my SQL coding is incorrect; I just started learning it. But if someone could point me in the right direction or tell me if I am going about this the correct way that would be greatly appreciated! The script I have right now is:
>
>> require(RODBC)
>> channel<-odbcConnect("MeganXE")
>> stbl<-sqlQuery(channel, 'select plotnum, sampyear, sptype from density')
>> sqlQuery(channel, 'select count (sampyear, plotnum, sptype) from stbl where sampyear=1995 AND plotnum=1 AND sptype='S' OR sptype='H')
>
> I get this error: unexpected symbol in "sqlQuery(channel...)"
>
> I would like R to return a count of how many records satisfy the condition of being sampled in 1995 and in plot number 1, where the species type is either softwood or hardwood (S or H). Any help with this would be great.
>
> Thanks in advance,
>
> Megan
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595