sql query

[tsp]

hi,
i m new in this oracle world i have one prob.regarding sql query.

here is the table
skuid unit date sites
1 10 20060804 00548
4 0 20060804 123
3 23 20060809 512
9 5 20060810 896
6 2 20060808 127
1 45 20060807 3258
1 86 20060811 6548
6 20 20060809 878
4 12 20060807 5214
ohhhhhhhhhh, its my table
and i want the output is as follows
skuid no.of sites date_0804 date_0807 ....o811
1 2 10 45 86
so on..... wrt skuid

[tattooedscorpdc]

You will need to leave the date as it is in the Oracle table as this is how Oracle stores date fields... I suggest using the language you are programming in to reformat and display the date as you want it to appear. Or you can look into other database solutions like SQL Server that will allow you to store dates in multipe formats ie 1/10/2009 or January 10, 2009 etc

Hope this helps

Larry D
MS Architect Evangelist