Module: Sequel::Oracle::DatasetMethods

Includes:
Dataset::SQLStandardDateFormat, Dataset::UnsupportedIntersectExceptAll
Included in:
JDBC::Oracle::Dataset, Dataset
Defined in:
lib/sequel/adapters/shared/oracle.rb

Constant Summary collapse

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

Instance Method Summary collapse

Instance Method Details

#distinct(*columns) ⇒ Object

Oracle doesn’t support DISTINCT ON

Raises:



23
24
25
26
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 23

def distinct(*columns)
  raise(Error, "DISTINCT ON not supported by Oracle") unless columns.empty?
  super
end

#empty? ⇒ Boolean

Returns:

  • (Boolean) 


34
35
36
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 34

def empty?
  db[:dual].where(exists).get(1) == nil
end

#except(dataset, all = false) ⇒ Object

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

Raises:



29
30
31
32
 
# File 'lib/sequel/adapters/shared/oracle.rb', line 29

def except(dataset, all = false)
  raise(Sequel::Error, "EXCEPT ALL not supported") if all
  compound_clone(:minus, dataset, all)
end