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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 16 Mar 2005 13:24:22 -0500
Message-ID: <jISdnerT_NxH5KXfRVn-hA@comcast.com>

"Stef" <s.fauchille_at_hotmail.com> wrote in message news:423878d2$0$3125$8fcfb975_at_news.wanadoo.fr...
> The version is 10g
> The error message isinvalid column
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message de
> news: 23ug315p8v5mokd8f1tpo1m311hm92vn4t_at_4ax.com...
>> On Wed, 16 Mar 2005 17:46:22 +0100, "Stef" <s.fauchille_at_hotmail.com>
>> wrote:
>>
>>>The code is
>>>
>>> SELECT DateTime,Description,(SELECT Description FROM MaTable WHERE
>>>DateTime>= T1.DateTime) As DecrNextRow FROM MaTable T1
>>>
>>>Can you help me
>>
>> And your Oracle version is?
>>
>> No answer without version!
>>
>> --
>> Sybrand Bakker, Senior Oracle DBA
>
>

please post the complete statement and the complete error message

++ mcs Received on Wed Mar 16 2005 - 12:24:22 CST