Class/Module Index [+]

Quicksearch

Sequel::Oracle::DatabaseMethods

Attributes

autosequence[RW]

Public Instance Methods

create_sequence(name, opts={}) click to toggle source
# File lib/sequel/adapters/shared/oracle.rb, line 13
def create_sequence(name, opts={})
  self << create_sequence_sql(name, opts)
end
create_trigger(*args) click to toggle source
# File lib/sequel/adapters/shared/oracle.rb, line 17
def create_trigger(*args)
  self << create_trigger_sql(*args)
end
current_user() click to toggle source
# File lib/sequel/adapters/shared/oracle.rb, line 21
def current_user
  @current_user ||= metadata_dataset.get{sys_context('USERENV', 'CURRENT_USER')}
end
database_type() click to toggle source

Oracle uses the :oracle database type

# File lib/sequel/adapters/shared/oracle.rb, line 30
def database_type
  :oracle
end
drop_sequence(name) click to toggle source
# File lib/sequel/adapters/shared/oracle.rb, line 25
def drop_sequence(name)
  self << drop_sequence_sql(name)
end
global_index_namespace?() click to toggle source

Oracle namespaces indexes per table.

# File lib/sequel/adapters/shared/oracle.rb, line 35
def global_index_namespace?
  false
end
supports_deferrable_constraints?() click to toggle source

Oracle supports deferrable constraints.

# File lib/sequel/adapters/shared/oracle.rb, line 55
def supports_deferrable_constraints?
  true
end
supports_transaction_isolation_levels?() click to toggle source

DB2 supports transaction isolation levels.

# File lib/sequel/adapters/shared/oracle.rb, line 60
def supports_transaction_isolation_levels?
  true
end
tables(opts={}) click to toggle source
# File lib/sequel/adapters/shared/oracle.rb, line 39
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
view_exists?(name) click to toggle source
# File lib/sequel/adapters/shared/oracle.rb, line 49
def view_exists?(name) 
  m = input_identifier_meth
  metadata_dataset.from(:tab).filter(:tname =>m.call(name), :tabtype => 'VIEW').count > 0 
end
views(opts={}) click to toggle source
# File lib/sequel/adapters/shared/oracle.rb, line 44
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

[Validate]

Generated with the Darkfish Rdoc Generator 2.