Displaying 1 result from an estimated 1 matches for "sample_yea".
Did you mean:
sample_a
2008 Jul 23
2
Using RODBC to use SQL queries
...few websites that go over the SQL language. I can connect to my database fine using
>channel<-odbcConnect("Oracle ODBC")
# then am prompted to enter my user id and password
After that I'd like to use the odbcQuery function and the SQL statement:
SELECT * FROM table_name WHERE SAMPLE_YEA LIKE "1965%"
According to the RODBC PDF, the odbcQuery command should accept any valid SQL statement. Is there something wrong with my syntax? I have tried a few things, like attaching the tables to the data frame but with no luck. According to the PDF, I should be able to use this argume...