Displaying 1 result from an estimated 1 matches for "vesselyear".
2010 Feb 26
1
RODBC looping sql script
Dear R users,
I am querying an Oracle database using sqlQuery() from the RODBC
package. What I would like to do is embed my R Sql query in a for loop.
For example
suppose the data.frame "vessel" contains two columns: vessel[,1]= vessel
id and vessel[,2]=permit year
I am using "vessel" as an input in a SQL based function that require
inputs of permit year and vessel id