Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com On Thu, Oct 18, 2012 at 8:24 AM, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>wrote: > Hi friends, > 1.) I would like to understand why this query is not working properly in > this situation: > > > I think it unlikely you will get much help with this request in its current form. The reason: too much SQL and no test case. Try creating a simple test case that can be presented here the demonstrates the issue. That means the code to build the table, populate the table, and reproduce the issue you see. The by-product of building a test case is often the solution to the problem. :) Jared -- //www.freelists.org/webpage/oracle-l