PL/SQL格式化字节

最新推荐文章于 2025-07-06 09:56:34 发布

原创最新推荐文章于 2025-07-06 09:56:34 发布 · 318 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#plsql

Oracle 专栏收录该内容

8 篇文章

订阅专栏

create or replace function format_bytes(pi_bytes in number) return varchar2
is
  c_unit constant number := 1024;
  l_size number;
  l_unit_ind integer;
begin
  l_size := pi_bytes;
  l_unit_ind := 0;
  while l_size > c_unit loop
    l_size := l_size / c_unit;
    l_unit_ind := l_unit_ind + 1;
  end loop;
  case
    when l_unit_ind = 0 then
      return l_size||'B';
    when l_unit_ind = 1 then
      return round(l_size, 2)||'KB';
    when l_unit_ind = 2 then
      return round(l_size, 2)||'MB';
    when l_unit_ind = 3 then
      return round(l_size, 2)||'GB';
    when l_unit_ind = 4 then
      return round(l_size, 2)||'TB';
    when l_unit_ind = 5 then
      return round(l_size, 2)||'PB';
    else
      return pi_bytes||'B';
  end case;
exception
  when others then
    return pi_bytes||'B';
end format_bytes;
/