subject:"SQL question \- crosstab in oracle"

SQL question - crosstab in oracle

2003-07-08 Thread Stephen . HODGKINSON

Hi I have a table with the following structure. CHECK_DATE DATE PHYRDS NUMBER(20) PHYWRTSNUMBER(20) PHYBLKRD

Re: SQL question - crosstab in oracle

2003-07-08 Thread Jay Wade

There are several ways to handle this. If you do a search for pivot on AskTom you will get a good sampling of them. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQL question - crosstab in oracle Date: Tue, 08 Jul 2003 06