Oracle 实现时间序列化

最新推荐文章于 2022-01-12 18:30:20 发布

IT的鱼

最新推荐文章于 2022-01-12 18:30:20 发布

阅读量804

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qq_32521313/article/details/89873792

版权

数据库专栏收录该内容

19 篇文章 0 订阅

订阅专栏

-- Declare result set.
create or replace type ytt_num is object
( n number);

create or replace type numbers_table is table of ytt_num;

-- Function body.
-- Created by ytt.
-- 2015/12/9
create or replace function ytt_generate_series
(
f_start_num number := 1, -- Start number.
f_end_num number,  -- Finish number.
f_step_num number := 1 -- Step.
)
return numbers_table pipelined
is 
  list numbers_table := numbers_table();
  i number := 0;
  j number := 1;
begin
  i := f_start_num;
  j := 1;
  -- Increase nested table's size.
  list.extend(f_end_num);
  -- Loop begin.
  while i <= f_end_num loop
  -- Initlization.
    list(j) := ytt_num(null);
    list(j).n := i;
    pipe row(list(j));
    i := i + f_step_num;
    j := j + 1;
  end loop;
  return;
end;

  select to_char(sysdate - n,'YYYY-MM-DD') from table(ytt_generate_series(1,10));