Contents

create or replace package binary#
is
  function to_decimal (
    i_binary                                      varchar2
  ) return pls_integer;
end binary#;
/
 
create or replace package body binary#
is
  function to_decimal (
    i_binary                                      varchar2
  ) return pls_integer
  is
    l_pos_fact                      pls_integer := 1;
    l_pos_val                       number(1);
    l_pos                           pls_integer := length(i_binary);
    l_char                          char(1);
    l_decimal                       pls_integer := 0;
  begin
    while l_pos > 0 loop
      l_pos_val := substr(i_binary, l_pos, 1);
      if(not l_pos_val between 0 and 1) then
        raise value_error;
      end if;
      l_decimal  := l_decimal + substr(i_binary, l_pos, 1) * l_pos_fact;
      l_pos      := l_pos - 1;
      l_pos_fact := l_pos_fact * 2;
    end loop;
    return l_decimal;
  exception
    when value_error then
      return 0;
  end to_decimal;
end binary#;
/

Version data entries

396 entries across 396 versions & 1 rubygems

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