Module | Sequel::Oracle::DatasetMethods |
In: |
lib/sequel/adapters/shared/oracle.rb
|
SELECT_CLAUSE_METHODS | = | Dataset.clause_methods(:select, %w'with distinct columns from join where group having compounds order limit lock') |
# File lib/sequel/adapters/shared/oracle.rb, line 117 117: def empty? 118: db[:dual].where(exists).get(1) == nil 119: end
Oracle uses MINUS instead of EXCEPT, and doesn‘t support EXCEPT ALL
# File lib/sequel/adapters/shared/oracle.rb, line 111 111: def except(dataset, opts={}) 112: opts = {:all=>opts} unless opts.is_a?(Hash) 113: raise(Sequel::Error, "EXCEPT ALL not supported") if opts[:all] 114: compound_clone(:minus, dataset, opts) 115: end
If this dataset is associated with a sequence, return the most recently inserted sequence value.
# File lib/sequel/adapters/shared/oracle.rb, line 123 123: def insert(*args) 124: r = super 125: if s = opts[:sequence] 126: with_sql("SELECT #{literal(s)}.currval FROM dual").single_value.to_i 127: else 128: r 129: end 130: end