Contents

create or replace package series#
is
  function square_of_sums (
    i_num                                         pls_integer
  ) return number;
  function sum_of_squares (
    i_num                                         pls_integer
  ) return number;
  function diff_of_squares (
    i_num                                         pls_integer
  ) return number;
end series#;
/
 
create or replace package body series#
is
  function square_of_sums (
    i_num                                         pls_integer
  ) return number
  is
  begin
    return power(i_num * (i_num + 1) / 2, 2);
  end square_of_sums;
  function sum_of_squares (
    i_num                                         pls_integer
  ) return number
  is
  begin
    return power(i_num, 3) / 3 + power(i_num, 2) / 2 + i_num / 6;
  end sum_of_squares;
  function diff_of_squares (
    i_num                                         pls_integer
  ) return number
  is
  begin
    return (power(i_num, 4) - power(i_num, 2)) / 4 + (power(i_num, 3) - i_num) / 6;
  end diff_of_squares;
end series#;
/

Version data entries

396 entries across 396 versions & 1 rubygems

Version	Path
trackler-2.2.1.180	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.179	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.178	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.177	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.176	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.175	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.174	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.173	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.172	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.171	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.170	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.169	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.167	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.166	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.165	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.164	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.163	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.162	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.161	tracks/plsql/exercises/difference-of-squares/example.plsql
trackler-2.2.1.160	tracks/plsql/exercises/difference-of-squares/example.plsql