SQL Snippets ™: Tutorials for Oracle Developers

create table n2w ( i number, test_group varchar2(10) );

insert into n2w values ( null      , 'A' ) ;
insert into n2w values ( 1         , 'A' ) ;
insert into n2w values ( 12        , 'A' ) ;
insert into n2w values ( 123       , 'A' ) ;
insert into n2w values ( 1234      , 'A' ) ;
insert into n2w values ( 12345     , 'A' ) ;
insert into n2w values ( 123456    , 'A' ) ;
insert into n2w values ( 1234567   , 'A' ) ;
insert into n2w values ( 1721057   , 'A' ) ;
insert into n2w values ( 1721424   , 'A' ) ;
insert into n2w values ( 5373484   , 'A' ) ;

insert into n2w values ( 0         , 'B' ) ;
insert into n2w values ( 1721058   , 'B' ) ;
insert into n2w values ( 1721300   , 'B' ) ;
insert into n2w values ( 1721423   , 'B' ) ;
insert into n2w values ( 5373485   , 'B' ) ;
insert into n2w values ( 7777777   , 'B' ) ;
insert into n2w values ( 9999999   , 'B' ) ;
insert into n2w values ( 20000000  , 'B' ) ;
insert into n2w values ( 200000000 , 'B' ) ;
insert into n2w values ( 777777007 , 'B' ) ;

insert into n2w values ( -123456789, 'C' ) ;
insert into n2w values ( -1        , 'C' ) ;
insert into n2w values ( 12345678  , 'C' ) ;
insert into n2w values ( 123456789 , 'C' ) ;
insert into n2w values ( 77777777  , 'C' ) ;
insert into n2w values ( 777777777 , 'C' ) ;
insert into n2w values ( 777777011 , 'C' ) ;

commit;