Re: SQLServer/Oracle Views
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/05/04
- Next message: Anith Sen: "Re: bitwise OR"
- Previous message: Tibor Karaszi: "Re: OUTER JOIN Problem"
- In reply to: Mike John: "Re: SQLServer/Oracle Views"
- Next in thread: Hugo Kornelis: "Re: SQLServer/Oracle Views"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 5 Jun 2004 17:59:09 +0200
I suggest checking the archives for some of Joe Celko's posts on the subject. I recall him stating that the
Oracle OJ ANSI SQL syntax is only cosmetics, which can mean that it still doesn't expose the semantics
according to ANSI SQL. I haven't worked with SQL Server, so I can't confirm that, just thought I mention this
for further investigation...
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Mike John" <Mike.John@knowledgepool.spamtrap.com> wrote in message news:OdEf$OmSEHA.3564@TK2MSFTNGP10.phx.gbl... This probably refers to views based on outer joins using the old (Non ansi) join syntax of *= being used in the where clause.These were of different syntax to how Oracle defined them. If you stick to the Ansi jojn syntax (left outer, right outer clauses etc) then I do not believe you will have any problems. Mike John "ClaireB" <anonymous@discussions.microsoft.com> wrote in message news:9081005F-9456-4DF3-AE67-1196CD802E2D@microsoft.com... > Hi, > > I am working on a project which is developing an application which will run on both SQLServer 2000 and Oracle 8i and 9i platforms. The views are developed on a Oracle platform and then translated into SQLServer. > > I have been investigating differences to be aware of when creating views for these two environments and have found the following on the Microsoft site..... > > 'When a view is defined with an outer join and is queried with a qualification on a column from the inner table of the outer join, the results from SQL Server and Oracle can differ. In most cases, Oracle views are easily translated into SQL Server views.' > > I am interested in the statement 'the results can differ'. Has anyone had experience of creating views that need to return the same data from an Oracle and SQLServer database and seen differences in results returned? > > Thanks > Claire > >
- Next message: Anith Sen: "Re: bitwise OR"
- Previous message: Tibor Karaszi: "Re: OUTER JOIN Problem"
- In reply to: Mike John: "Re: SQLServer/Oracle Views"
- Next in thread: Hugo Kornelis: "Re: SQLServer/Oracle Views"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
