| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: tricky SQL
BCJM, first "How do you right one" should be "How do you write one"
Second, use the advanced search option from http://groups.google.com to search the comp.databases.oracle.server and .misc archives for "pivot table"
Just write a query that find you the correct rows and feed that to a query to pivot the results.
HTH -- Mark D Powell -- Received on Thu Mar 03 2005 - 09:36:53 CST
![]() |
![]() |