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

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 16 Mar 2005 20:20:46 -0000
Message-ID: <423894f6$0$10945$cc9e4d1f@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 Wed Mar 16 2005 - 14:20:46 CST