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

Methods

distinct   empty?   except  

Included Modules

Dataset::UnsupportedIntersectExceptAll Dataset::SQLStandardDateFormat

Constants

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

Public Instance methods

Oracle doesn‘t support DISTINCT ON

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 23
23:       def distinct(*columns)
24:         raise(Error, "DISTINCT ON not supported by Oracle") unless columns.empty?
25:         super
26:       end

[Source]

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

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

[Source]

    # File lib/sequel/adapters/shared/oracle.rb, line 29
29:       def except(dataset, all = false)
30:         raise(Sequel::Error, "EXCEPT ALL not supported") if all
31:         compound_clone(:minus, dataset, all)
32:       end

[Validate]