bit shift function

bit shift function

with
        function shift
        (
                p_number        in number,
                p_bits          in number
        )
                return number
        as
        begin
                return p_number * power( 2, p_bits );
        end shift;

cnt as
(
        select level - 6 n
        from dual
        connect by level <= 11
)
select
        n, shift( 1, n )
from cnt
/

SQL> @ bitshift.sql

         N SHIFT(1,N)
---------- ----------
        -5     .03125
        -4      .0625
        -3       .125
        -2        .25
        -1         .5
         0          1
         1          2
         2          4
         3          8
         4         16
         5         32

11 rows selected.