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: Stef <s.fauchille_at_hotmail.com>
Date: Wed, 16 Mar 2005 19:20:10 +0100
Message-ID: <423878d2$0$3125$8fcfb975@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
Received on Wed Mar 16 2005 - 12:20:10 CST

Original text of this message

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