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') |
# File lib/sequel/adapters/shared/oracle.rb, line 108 108: def empty? 109: db[:dual].where(exists).get(1) == nil 110: end
Oracle uses MINUS instead of EXCEPT, and doesn‘t support EXCEPT ALL
# 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
If this dataset is associated with a sequence, return the most recently inserted sequence value.
# 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