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

Methods

Constants

SELECT_CLAUSE_ORDER = %w'with distinct columns from join where group having compounds order limit'.freeze

Public Instance methods

[Source]

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

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, all = false)
103:         raise(Sequel::Error, "EXCEPT ALL not supported") if all
104:         compound_clone(:minus, dataset, all)
105:       end

Oracle requires SQL standard datetimes

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 112
112:       def requires_sql_standard_datetimes?
113:         true
114:       end

Oracle does not support DISTINCT ON

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 117
117:       def supports_distinct_on?
118:         false
119:       end

Oracle does not support INTERSECT ALL or EXCEPT ALL

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 122
122:       def supports_intersect_except_all?
123:         false
124:       end

Oracle supports timezones in literal timestamps.

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 127
127:       def supports_timestamp_timezones?
128:         true
129:       end

Oracle supports window functions

[Source]

     # File lib/sequel/adapters/shared/oracle.rb, line 132
132:       def supports_window_functions?
133:         true
134:       end

[Validate]