Entry 758

PL/SQL

Submitted by anonymous on May 7, 2008 at 1:21 p.m.
Language: SQL. Code size: 308 bytes.

CREATE OR REPLACE function DEVELOP.DateRange(aStart date, aNumber integer)
  return DATE_TABLE_TYPE pipelined
is
  vNextValue date;
begin
  vNextValue  := trunc(aStart);

  for x in 0 .. abs(aNumber)-1 loop
    pipe row(vNextValue +(x * sign(aNumber) ) );
  end loop;

  return;
end DateRange;
/

This snippet took 0.01 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).