# File lib/sequel/adapters/shared/oracle.rb, line 11 def create_sequence(name, opts={}) self << create_sequence_sql(name, opts) end
# File lib/sequel/adapters/shared/oracle.rb, line 15 def create_trigger(*args) self << create_trigger_sql(*args) end
# File lib/sequel/adapters/shared/oracle.rb, line 19 def current_user @current_user ||= metadata_dataset.get{sys_context('USERENV', 'CURRENT_USER')} end
Oracle uses the :oracle database type
# File lib/sequel/adapters/shared/oracle.rb, line 28 def database_type :oracle end
# File lib/sequel/adapters/shared/oracle.rb, line 23 def drop_sequence(name) self << drop_sequence_sql(name) end
Oracle namespaces indexes per table.
# File lib/sequel/adapters/shared/oracle.rb, line 33 def global_index_namespace? false end
Oracle supports deferrable constraints.
# File lib/sequel/adapters/shared/oracle.rb, line 53 def supports_deferrable_constraints? true end
DB2 supports transaction isolation levels.
# File lib/sequel/adapters/shared/oracle.rb, line 58 def supports_transaction_isolation_levels? true end
# File lib/sequel/adapters/shared/oracle.rb, line 37 def tables(opts={}) m = output_identifier_meth metadata_dataset.from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'TABLE').map{|r| m.call(r[:tname])} end
# File lib/sequel/adapters/shared/oracle.rb, line 47 def view_exists?(name) m = input_identifier_meth metadata_dataset.from(:tab).filter(:tname =>m.call(name), :tabtype => 'VIEW').count > 0 end
# File lib/sequel/adapters/shared/oracle.rb, line 42 def views(opts={}) m = output_identifier_meth metadata_dataset.from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'VIEW').map{|r| m.call(r[:tname])} end