require "dbi"

DBI.connect("dbi:Oracle:orcl", "username", "password" ) { |dbh|
  dbh.prepare("select * from tablename") { |sth|
    sth.execute(tablespace)
    sth.each { |row|
      p row
    }
  }
}