search for: sql_code

...database connection via RODBC. So I can acces every part with its distinct code by a SQL Query. For every part, the SQL Query has to be adapted for the parts name. My idea was to generate the SQL Code in Excel for ervery part and save this as an txt-file. So I can define the SQL-Codes as an object (SQL_Code <- load.table("...txt, header = FALSE). In the next step I can build a loop, which tells R to go through the object SQL_Code line for line, using the text for the SQL Query. The code is as follows: SQL Code in the sqlparts.txt. file: "SELECT table.* FROM table WHERE ((table.part) =...

I''m just looking into how to connect to Oracle using Rails. I''ve got everything connecting and working as it should. I have a Users table in Oracle: create_table "users", :force => true do |t| t.column "username", :string t.column "created_on", :datetime t.column "email", :string t.column "note", :text