SQL & PL/SQL

This is Part1 (strange results of nth_Value)
from 1118408

SQL> with t(empno,sal,rn) as(
  2  select 101, 720,1 from dual union
  3  select 102, 850,2 from dual union
  4  select 103,1250,3 from dual union
  5  select 105,1700,4 from dual)
  6  select
  7  nth_Value(empno,rn) over(order by empno
  8  Rows between Unbounded Preceding
  9           and Unbounded Following) as emp,
 10  nth_Value(sal,rn) over(order by sal
 11  Rows between Unbounded Preceding
 12           and Unbounded Following) as sal
 13  from t;

EMP  SAL
---  ---
101  720
101  720
101  720
101  720

This is Part2 (strange results of recursive with clause)
from 1061530

SQL> with tmp(day1) as(select date '2009-06-01' from dual),
  2  rec(day1) as(
  3  select day1 from tmp
  4  union all
  5  select add_months(day1,1)
  6    from rec
  7   where add_months(day1,1) < date '2010-05-05')
  8  select * from rec;
select add_months(day1,1)
       *
ERROR at line 5:
ORA-01790: expression must have same datatype as corresponding expression

SQL> with rec(dayc,LV) as(
  2  select cast(date '2010-04-15' as date),1 from dual
  3  union all
  4  select cast(dayc+1 as date),LV+1
  5    from rec
  6   where LV<= 3)
  7  select * from rec;

DAYC      LV
--------  --
10-04-15   1
10-04-14   2
10-04-13   3
10-04-12   4

I may be missing some background information (from previous threads etc.) but have you reported the supposed bug or incorrect results via MOS? Forums is not used as an official support channel.

If this is specific only to 11g XE Beta, then you may have som luck reporting this in {forum:id=1378} (as XE has no direct support... hm, but maybe maybe e.g. backports could be pre-packaged in the XE production/GA release).

unfortunately,I cannot use support :-(

I did not know that there is OracleXE user feedBack forum.
I have been reported this thread in 2223718
Thanks.