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

I am no specialist in SQL Server, but I take it that datetime is a reserved word in SQL Server which correspondents to sysdate.

This is only a shot in the dark, so it might be wrong.

hth
Rene

On 2005-03-16, Stef <s.fauchille_at_hotmail.com> wrote:
> 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
>

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/