From oracle-l-bounce@freelists.org Sat Jul 31 19:28:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i710SFe19762 for ; Sat, 31 Jul 2004 19:28:15 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i710SFI19757 for ; Sat, 31 Jul 2004 19:28:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 17DDC72C1ED; Sat, 31 Jul 2004 19:06:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05282-57; Sat, 31 Jul 2004 19:06:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 674E172C1BA; Sat, 31 Jul 2004 19:06:13 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 31 Jul 2004 19:04:47 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 34A2072C026 for ; Sat, 31 Jul 2004 19:04:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03369-70 for ; Sat, 31 Jul 2004 19:04:47 -0500 (EST) Received: from mail012.syd.optusnet.com.au (mail012.syd.optusnet.com.au [211.29.132.66]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BAEB772C18C for ; Sat, 31 Jul 2004 19:04:45 -0500 (EST) Received: from optusnet.com.au (c210-49-170-191.brasd1.vic.optusnet.com.au [210.49.170.191]) (authenticated) by mail012.syd.optusnet.com.au (8.11.6p2/8.11.6) with ESMTP id i710WNd26140 for ; Sun, 1 Aug 2004 10:32:23 +1000 Message-ID: <410C3AC6.6070105@optusnet.com.au> Date: Sun, 01 Aug 2004 10:35:18 +1000 From: Kresimir Fabijanic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: how to generate the output w/o using temp table References: In-Reply-To: Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 6572 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kfabijanic@optusnet.com.au Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Grace Have you tried this? select startdate outdate , id from union all select enddate outdate ,id from
order by 1 HTH Kind regards Kresimir Fabijanic mglim2@softhome.net wrote: >Hi, > >I got a table w/ the ff: data > >id startdate enddate >1 10/01/2004 12/13/2004 >2 12/01/2004 12/02/2005 >3 12/03/2004 02/20/2005 > > >need to produce the ff:output > >mm/yyy id >11/2004 1 >12/2004 1 >12/2004 2 >12/2004 3 >01/2005 3 >02/2005 3 > >how can i produce this result w/o using a temporary table in my select >stmt? > > > >Best Regards, >Grace Lim >Suy Sing Comm'l Corp > >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@freelists.org >put 'unsubscribe' in the subject line. >-- >Archives are at http://www.freelists.org/archives/oracle-l/ >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------