Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: VIEW who works in SQL Server but not in ORACLE

Re: VIEW who works in SQL Server but not in ORACLE

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 16 Mar 2005 12:00:48 -0500
Message-ID: <no2dnSfG_fLf-6XfRVn-sQ@comcast.com>

"Stef" <s.fauchille_at_hotmail.com> wrote in message news:423862d7$0$807$8fcfb975_at_news.wanadoo.fr...
> Hello,
>
> I need some help,
>
> I have a view write into a SQL Server database that I'd like to put on an
> ORACLE Database
>
> The code is
>
> SELECT DateTime,Description,(SELECT Description FROM MaTable WHERE
> DateTime>= T1.DateTime) As DecrNextRow FROM MaTable T1
>
> Can you help me
>
> --
> Stef
>

what happened when you tried it on the oracle database?

++ mcs Received on Wed Mar 16 2005 - 11:00:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US