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

Methods

Constants

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

Public Instance methods

[Source]

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

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 11
11:       def create_trigger(*args)
12:         self << create_trigger_sql(*args)
13:       end

Oracle uses the :oracle database type

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 20
20:       def database_type
21:         :oracle
22:       end

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 15
15:       def drop_sequence(name)
16:         self << drop_sequence_sql(name)
17:       end

[Source]

    # 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

[Source]

    # 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

[Source]

    # 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

[Source]

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

[Validate]