Conversion of SQL Server Query to Oracle

From: vikas_kumar <vikas_kumar_at_inf.com>
Date: Sun, 29 Aug 1999 23:26:06 +0530
Message-ID: <B256397740BDD211A3560008C7F41A0EF6C25D@punmsg01>

I have two queries which run on SQL Server but not on Oracle How do i convert them on Oracle

SELECT * From rptGroupView, CshptDetails, Area, Region, rptMissingFilesLoadedOrdHeader, rptMissingFilesLoadedTradDays Where (CshptDetails.CashpointCode *= rptMissingFilesLoadedTradDays.cashpointcode OR CshptDetails.CashpointCode *= rptMissingFilesLoadedOrdHeader.cashpointcode ) AND
- Reason : Oracle does not allow OR with outer joins

2)Select * from reportdates, MonthDetail, CshptDetails,Region,Area where

                 CshptDetails.CashpointCode *= MonthDetail.CashpointCode and

                 MonthDetail.YearMonth =* reportdates.reportyearmonth

Reason : Oracle does not allow Queries of type A*=B and C*= B Query ie A=B(+) and C=B(+)

Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't. Received on Sun Aug 29 1999 - 12:56:06 CDT