| Module | Sequel::Oracle::DatabaseMethods |
| In: |
lib/sequel/adapters/shared/oracle.rb
|
| TEMPORARY | = | 'GLOBAL TEMPORARY '.freeze |
| AUTOINCREMENT | = | ''.freeze |
| autosequence | [RW] |
# File lib/sequel/adapters/shared/oracle.rb, line 11
11: def create_sequence(name, opts={})
12: self << create_sequence_sql(name, opts)
13: end
# File lib/sequel/adapters/shared/oracle.rb, line 15
15: def create_trigger(*args)
16: self << create_trigger_sql(*args)
17: end
# File lib/sequel/adapters/shared/oracle.rb, line 19
19: def current_user
20: @current_user ||= get{sys_context('USERENV', 'CURRENT_USER')}
21: end
# File lib/sequel/adapters/shared/oracle.rb, line 23
23: def drop_sequence(name)
24: self << drop_sequence_sql(name)
25: end
# File lib/sequel/adapters/shared/oracle.rb, line 32
32: def tables(opts={})
33: ds = from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'TABLE')
34: ds.map{|r| ds.send(:output_identifier, r[:tname])}
35: end
# File lib/sequel/adapters/shared/oracle.rb, line 42
42: def view_exists?(name)
43: from(:tab).filter(:tname =>dataset.send(:input_identifier, name), :tabtype => 'VIEW').count > 0
44: end