Module Sequel::Oracle::DatabaseMethods
In: lib/sequel/adapters/shared/oracle.rb

Methods

Constants

TEMPORARY = 'GLOBAL TEMPORARY '.freeze
AUTOINCREMENT = ''.freeze

Attributes

autosequence  [RW] 

Public Instance methods

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 11
11:       def create_sequence(name, opts={})
12:         self << create_sequence_sql(name, opts)
13:       end

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 15
15:       def create_trigger(*args)
16:         self << create_trigger_sql(*args)
17:       end

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 19
19:       def current_user
20:         @current_user ||= get{sys_context('USERENV', 'CURRENT_USER')}
21:       end

Oracle uses the :oracle database type

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 28
28:       def database_type
29:         :oracle
30:       end

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 23
23:       def drop_sequence(name)
24:         self << drop_sequence_sql(name)
25:       end

[Source]

    # 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

[Source]

    # 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

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 37
37:       def views(opts={}) 
38:         ds = from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'VIEW') 
39:         ds.map{|r| ds.send(:output_identifier, r[:tname])} 
40:       end

[Validate]