Contents

require 'spec_helper'

# load 'betwnstr' procedure into the database
require "betwnstr"

describe "Between string" do
  it "should be correct in normal case" do
    plsql.betwnstr('abcdefg', 2, 5).should == 'bcde'
  end

  it "should be correct with zero start value" do
    plsql.betwnstr('abcdefg', 0, 5).should == 'abcde'
  end

  it "should be correct with way big end value" do
    plsql.betwnstr('abcdefg', 5, 500).should == 'efg'
  end

  it "should be correct with NULL string" do
    plsql.betwnstr(NULL, 5, 500).should == NULL
  end

end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
ruby-plsql-spec-0.4.0	examples/spec/betwnstr_spec.rb
ruby-plsql-spec-0.3.0	examples/spec/betwnstr_spec.rb
ruby-plsql-spec-0.2.1	examples/spec/betwnstr_spec.rb
ruby-plsql-spec-0.1.0	examples/spec/betwnstr_spec.rb