Order by with partition

From: Dean Paul <oracledbam_at_hotmail.com>
Date: Tue, 09 May 2006 12:47:09 -0400
Message-ID: <BAY117-F28FA564AF74AFCA2C13618D3A90@phx.gbl>

Hi,

can we use order by or group by on clause on partition? emp(last_name char(10), first_name char(20)); This table has 3 partition like p1,p2,pf. Can I get report like ,

partition       lastname first
partition1   xx                 aaa
                dd                pppp
partition2   ll                  jujuju
                lo                  kkkkk
partitionm ij                   sdjjdfj

Thanks

---

Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 09 2006 - 11:47:09 CDT