PL/SQL (MOSC)

MOSC Banner

gap less result

edited Oct 20, 2009 5:46PM in PL/SQL (MOSC) 9 commentsAnswered
Hi,

  i've a report  in this

lay out

                  day_1       day_2   day_3

code   

Problem :  in the columns day_1, day_2 and day_3....the values in each cell could be

1 record, 1 or more records..

example ... day_1              day_2              day_3        ---- this should be the output

                    xxxxx              xxxxxx           xxxxxxx

                                                                      xxxxxxxx

Problem 2 :  in my script ..i'm having a difefferent result. wherein i'm gaps in between

e.g.     day_1     day_2          day_3

                          

            xxxxxx         

                             xxxxxx   

                                                 xxxxxxxx 

                                                 xxxxxxxx

 many thanks

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