Sha256: 52623dbb37133d354386a898e3fd8759c1b0be5a2c0c0b1e4d0e7819b45c87af
Contents?: true
Size: 1.66 KB
Versions: 396
Compression:
Stored size: 1.66 KB
Contents
create or replace package ut_series#
is
procedure run;
end ut_series#;
/
create or replace package body ut_series#
is
procedure test (
i_descn varchar2
,i_exp number
,i_act number
)
is
begin
if i_exp = i_act then
dbms_output.put_line('SUCCESS: ' || i_descn);
else
dbms_output.put_line('FAILURE: ' || i_descn || ' - expected ' || nvl('' || i_exp, 'null') || ', but received ' || nvl('' || i_act, 'null'));
end if;
end test;
procedure run
is
begin
test(i_descn => 'test_square_of_sums_to_5' , i_exp => 225 , i_act => series#.square_of_sums(5) );
test(i_descn => 'test_sum_of_squares_to_5' , i_exp => 55 , i_act => series#.sum_of_squares(5) );
test(i_descn => 'test_difference_of_sums_to_5' , i_exp => 170 , i_act => series#.diff_of_squares(5) );
test(i_descn => 'test_square_of_sums_to_10' , i_exp => 3025 , i_act => series#.square_of_sums(10) );
test(i_descn => 'test_sum_of_squares_to_10' , i_exp => 385 , i_act => series#.sum_of_squares(10) );
test(i_descn => 'test_difference_of_sums_to_10' , i_exp => 2640 , i_act => series#.diff_of_squares(10) );
test(i_descn => 'test_square_of_sums_to_100' , i_exp => 25502500, i_act => series#.square_of_sums(100) );
test(i_descn => 'test_sum_of_squares_to_100' , i_exp => 338350 , i_act => series#.sum_of_squares(100) );
test(i_descn => 'test_difference_of_sums_to_100', i_exp => 25164150, i_act => series#.diff_of_squares(100));
end run;
end ut_series#;
/
begin
ut_series#.run;
end;
/
Version data entries
396 entries across 396 versions & 1 rubygems