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

Thank tou for your answer but it still doesn't work. I said something wrong, it's ORACLE 8i version.
Here is the code ( the column Acquit doesn't exist in my table, it's a self made in the request)
Sorry for my English

prd244pr > SELECT TIMESTMP , TRANSTYPE , TAGNME, DSCRPTN, 2 (SELECT TAGNAME FROM (
3 SELECT TAGNAME FROM RSV_ALM_LOG WHERE 4 TRANSTYPE = 'Acked' AND TIMESTMP > T1.TIMESTMP 5 AND TAGNAME = T1.TAGNAME)
6 WHERE ROWNUM = 1) AS ACQUIT
7 FROM RSV_ALM_LOG T1;
AND TAGNAME = T1.TAGNAME Error at line 5:
OAR-00904 : invalid column name

Oracle 8i Enterprise Edition Release 8.1.7.4.1 - Production PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.2.1 - Production
TNS for 32 bit windows : Version 8.1.7.4.0 - Production NLSRTL Version 3.4.1.0.0 - Production

What can I do.

Thanks

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> a écrit dans le message de news: 423894f6$0$10945$cc9e4d1f_at_news-text.dial.pipex.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
>
> Please could you post your DDL and error message, as you describe the code
> above works on 10g.
>
> SQL> create table MaTable(datetime date,description varchar2(10));
>
> Table created.
>
> SQL> create view v1
> 2 as
> 3 SELECT DateTime,Description,(SELECT Description FROM MaTable WHERE
> 4 DateTime>= T1.DateTime) As DecrNextRow FROM MaTable T1
> 5 ;
>
> View created.
>
> SQL> select banner from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
> PL/SQL Release 10.1.0.2.0 - Production
> CORE 10.1.0.2.0 Production
> TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
> NLSRTL Version 10.1.0.2.0 - Production
>
> SQL>
>
Received on Thu Mar 17 2005 - 02:56:47 CST