| Module | Sequel::Oracle::DatabaseMethods |
| In: |
lib/sequel/adapters/shared/oracle.rb
|
| TEMPORARY | = | 'GLOBAL TEMPORARY '.freeze |
| AUTOINCREMENT | = | ''.freeze |
# File lib/sequel/adapters/shared/oracle.rb, line 7 7: def create_sequence(name, opts={}) 8: self << create_sequence_sql(name, opts) 9: end
# File lib/sequel/adapters/shared/oracle.rb, line 11
11: def create_trigger(*args)
12: self << create_trigger_sql(*args)
13: end
# File lib/sequel/adapters/shared/oracle.rb, line 15
15: def drop_sequence(name)
16: self << drop_sequence_sql(name)
17: end
# File lib/sequel/adapters/shared/oracle.rb, line 29
29: def table_exists?(name)
30: from(:tab).filter(:tname =>dataset.send(:input_identifier, name), :tabtype => 'TABLE').count > 0
31: end
# File lib/sequel/adapters/shared/oracle.rb, line 24
24: def tables(opts={})
25: ds = from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'TABLE')
26: ds.map{|r| ds.send(:output_identifier, r[:tname])}
27: end
# File lib/sequel/adapters/shared/oracle.rb, line 38
38: def view_exists?(name)
39: from(:tab).filter(:tname =>dataset.send(:input_identifier, name), :tabtype => 'VIEW').count > 0
40: end