Module: Sequel::Oracle::DatabaseMethods

Included in:
JDBC::Oracle::DatabaseMethods, Database
Defined in:
lib/sequel/adapters/shared/oracle.rb

Instance Method Summary collapse

Instance Method Details

#table_exists?(name) ⇒ Boolean

Returns:

  • (Boolean) 


11
12
13
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 11

def table_exists?(name)
  from(:tab).filter(:tname =>dataset.send(:input_identifier, name), :tabtype => 'TABLE').count > 0
end

#tables(opts = {}) ⇒ Object 



6
7
8
9
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 6

def tables(opts={})
  ds = from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'TABLE')
  ds.map{|r| ds.send(:output_identifier, r[:tname])}
end