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 ||= metadata_dataset.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

Oracle namespaces indexes per table.

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 33
33:       def global_index_namespace?
34:         false
35:       end

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 37
37:       def tables(opts={})
38:         m = output_identifier_meth
39:         metadata_dataset.from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'TABLE').map{|r| m.call(r[:tname])}
40:       end

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 47
47:       def view_exists?(name) 
48:         m = input_identifier_meth
49:         metadata_dataset.from(:tab).filter(:tname =>m.call(name), :tabtype => 'VIEW').count > 0 
50:       end

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 42
42:       def views(opts={}) 
43:         m = output_identifier_meth
44:         metadata_dataset.from(:tab).server(opts[:server]).select(:tname).filter(:tabtype => 'VIEW').map{|r| m.call(r[:tname])}
45:       end

[Validate]