module FlydataCore
module Oracle

class QueryHelper
  # Set default schema if a schmema name is not given
  def self.schema_as_value(schema, user)
    s = schema.to_s.strip
    if s.empty?
      s = user.to_s.strip
    end
    "'#{s.upcase}'"
  end

  def self.tables_as_value(tables)
    tables.collect{|t| "'#{t.upcase}'"}.join(",")
  end
end

end
end