OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » How to Group

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Group [message #90105]

Thu, 28 October 2004 11:19

smth
Messages: 2
Registered: October 2004

Junior Member

Hi,

I have a table
Name - Day - Colour
ram - Monday - white
ram - wednesday - red
mohit - Tuesday - blue
mohit - wednesday - black
mohit - friday - white
purab - monday - yellow
rajesh- tuesday - black
rajesh- saturday - brown

i have to generate a report in the below format
name - Day - Colour
ram - Monday - white
ram - Tuesday - 0
ram - wednesday - red
ram - thursday - 0
ram - friday - 0
ram - saturday - 0
ram - sunday - 0

similarly for others also for the whole week, even though they do not have details for all the days in the week

Thanks

Report message to a moderator

Previous Topic:	Julian date mask & ORA-01821: date format not recognized
Next Topic:	Round Function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 09:20:49 CST 2024