use strict;
use warnings;
use Test::More;
use SQL::Maker::Select::Oracle;

my $sel = SQL::Maker::Select::Oracle->new( new_line => q{ } )
                                      ->add_select('foo')
                                      ->add_from('user')
                                      ->limit(10)
                                      ->offset(20);

is $sel->as_sql, 'SELECT * FROM ( SELECT foo, ROW_NUMBER() OVER (ORDER BY 1) R FROM user ) WHERE  R BETWEEN 20 + 1 AND 10 + 20';

done_testing;