Kategorie-Archiv: PL/SQL

LOV to pick month within an interval of half-a-year around current date

Oktober 17, 2013 Hendrik Gossens Hinterlasse einen Kommentar

In one of our famous APEX projects we had the requirement to select a month from a select list. The select list itself should contain all months half a year before and half a year after current date. Below you can see the select-statement of our LOV. Maybe it will be helpful for somebody out there.

 with dates as (
    select add_months(add_months(trunc(sysdate, 'MM'), -6), offset) first_day_of_month
    from (
      select level - 1 offset
      from dual
      connect by level <= 13
    )
  )
  select to_char(first_day_of_month, 'Month YYYY') display_value, to_char (first_day_of_month, 'YYYYMM') return_value 
  from dates

with dates as (

select add_months(add_months(trunc(sysdate, 'MM'), -6), offset) first_day_of_month

from (

select level - 1 offset

from dual

connect by level <= 13

)

select to_char(first_day_of_month, 'Month YYYY') display_value, to_char (first_day_of_month, 'YYYYMM') return_value

from dates

PL/SQL

ORU-10027

Februar 6, 2012 Hendrik Gossens Hinterlasse einen Kommentar

Today I ran into a really frustrating ORU-10027 runtime exception.
I will explain the circumstances and a solution later.

Note to me: Avoid quick and dirty debugging with

  dbms_output.put_line(v_value);

1	dbms_output.put_line(v_value);

Write a logger-package instead and reuse it in prospective projects…

shebangbeacon

Kategorie-Archiv: PL/SQL

LOV to pick month within an interval of half-a-year around current date

ORU-10027

Blog about Oracle ADF, MAF and related technologies