RE: Simply question (for gurus maybe)

RE: Simply question (for gurus maybe)

 

  

hi,

just try with start by conn with, prior combination, this gives the tree structure..

prob you will have to wait till regis/ganesh logs in..

question is interesting one...

good luck..subodh deshpande
--

--------- Original Message ---------

DATE: Thu, 26 Feb 2004 19:13:47
From: "sparacello" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed]

>In this Way I get
>ID DSTART DEND
>1 01/01/1900 05/02/2004
>2 15/10/2004 31/12/9999
>
>But I also need a
> 05/02/2004 15/10/2004
>row..
>
>

>
>
>> How about
>> Select a.ID01/01/1900 05/02/2004(a.startdate,b.startdate), least(a.enddate,b.enddate)
>> From table1 a, table2 b
>> Where a.id=b.id
>>
>>
>> -----Original Message-----
>> From: sparacello [mailto:[Email Address Removed]
>> Sent: Thursday, February 26, 2004 10:02 AM
>> To: LazyDBA.com Discussion
>> Subject: Simply question (for gurus maybe)
>>

>> I need to merge and intersect two table creating a new time interval.

>> date format = DD/MM/YYYY
>> I will try to semplificate my big table.. I just need to understand the WAY
>> table1
>> ID start_date end_date

>> 01 01/01/1900 05/02/2004
>> 02 05/02/2004 31/12/9999
>> table2
>> ID start_date end_date
>>
>> 01 01/01/1900 15/10/2004
>> 02 15/10/2004 31/12/9999
>> I need to have a view like this
>> 01 01/01/1900 05/02/2004
>> 02 05/02/2004 15/10/2004
>> 03 15/10/2004 31/12/9999
>>
>>
>> --
>> Email.it, the professional e-mail, gratis per te: http://www.email.it/f
>>

>> Sponsor:
>> Hai un sito web? Allora guadagna anche tu con il Web Marketing !
>> Collegati subito.
>> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1554&d=26-2
>>
>> --------
>> Get today's cartoon: http://www.LazyDBA.com
>> Please don't reply to RTFM questions
>> Oracle documentation is here: http://tahiti.oracle.com
>> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these terms:http://www.lazydba.com/legal.html
>>
>
>
>--
>Email.it, the professional e-mail, gratis per te: http://www.email.it/f
>
>Sponsor:
>Entra e acquista i migliori prodotti per PC e cellulari a prezzi shock!
>
>Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2021&d=26-2



____________________________________________________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10
Oracle LazyDBA home page