Module: Sequel::Oracle::DatasetMethods

Constants

SELECT_CLAUSE_METHODS = Dataset.clause_methods(:select, %w'with distinct columns from join where group having compounds order limit')

Public Instance methods

empty?()

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 108
108:       def empty?
109:         db[:dual].where(exists).get(1) == nil
110:       end

except(dataset, opts={})

Oracle uses MINUS instead of EXCEPT, and doesn‘t support EXCEPT ALL

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 102
102:       def except(dataset, opts={})
103:         opts = {:all=>opts} unless opts.is_a?(Hash)
104:         raise(Sequel::Error, "EXCEPT ALL not supported") if opts[:all]
105:         compound_clone(:minus, dataset, opts)
106:       end

insert(*args)

If this dataset is associated with a sequence, return the most recently inserted sequence value.

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 114
114:       def insert(*args)
115:         r = super
116:         if s = opts[:sequence]
117:           with_sql("SELECT #{literal(s)}.currval FROM dual").single_value.to_i
118:         else
119:           r
120:         end
121:       end

requires_sql_standard_datetimes?()

Oracle requires SQL standard datetimes

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 124
124:       def requires_sql_standard_datetimes?
125:         true
126:       end

sequence(s)

Create a copy of this dataset associated to the given sequence name, which will be used when calling insert to find the most recently inserted value for the sequence.

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 131
131:       def sequence(s)
132:         clone(:sequence=>s)
133:       end

supports_intersect_except_all?()

Oracle does not support INTERSECT ALL or EXCEPT ALL

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 136
136:       def supports_intersect_except_all?
137:         false
138:       end

supports_timestamp_timezones?()

Oracle supports timezones in literal timestamps.

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 141
141:       def supports_timestamp_timezones?
142:         true
143:       end

supports_window_functions?()

Oracle supports window functions

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 146
146:       def supports_window_functions?
147:         true
148:       end