SQL Performance (MOSC)

MOSC Banner

Query does not work in 11.2.0.3 release but works correctly in 11.2.0.1 release. In what could be th

edited May 23, 2013 6:48AM in SQL Performance (MOSC) 12 commentsAnswered
Query does not work in 11.2.0.3 release but works correctly in 11.2.0.1 release. In what could be the reason?

WITH sourc(id, name, parent) as (select t.id, t.name, LAG(id) over (order by id) parent
                                   FROM (select 1 id, 'a' name from dual
                                          union
                                         select 2, 'b' from dual
                                          union
                                         select 3, 'c' from dual
                                        ) t
                                 )                 ,
     stepbystep (id, name,  parent) AS (select s.id, to_char(s.name),  s.parent
                                 from sourc s
                                where id = 1
                                union all
                               SELECT s.id, r.name||','||s.name,  s.parent
                                 from sourc s, stepbystep r
                                where s.parent = r.id
                              )
SELECT * FROM stepbystep

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center