如何把access\sql server的sql语句转换成oracle的sql语句

20度的风

有现成的工具吗？谢谢！
SELECT ItemActivity.lngActivityID, ItemActivityDetail.lngRowID,
ItemActivity.strDate,
Customer.strCustomerName,Customer.strTaxNo,Customer.strCustomerCode,
CustomerAddress.strAddress & CustomerAddress.strOfficePhoneNumber As AddressAndPhone,
CustomerBank.strBankName &CustomerBank.strAccountNO As BankAccount,
Item.strItemCode, Item.strItemName, Item.strItemStyle,
ItemUnit.strUnitName, ItemUnit.dblFactor, ItemActivityDetail.dblQuantity,
ItemActivityDetail.dblCurrAmount,
ItemActivityDetail.dblCurrTaxAmount,
ItemActivityDetail.dblCurrAmount+ItemActivityDetail.dblCurrTaxAmount AS dblCurrTaxAmount1,
ItemActivityDetail.dblCurrPrice, ItemActivityDetail.dblCurrPriceTax AS dblCurrTaxPrice,
IIF(ItemActivity.lngReceiptTypeID =8,Tax.dblPurchaseTaxRate,Tax.dblSaleTaxRate) AS dblTaxRate,
ItemActivity.strInvoiceNumber,ItemActivity.strReceiptDate,
ItemActivity.strNote,
ItemActivity.lngSourceActivityID,
Format(ItemActivity.intYear)+Format(ItemActivity.bytPeriod,'00') & ItemActivity.strReceiptNO & Format(ItemActivity.lngReceiptNO,'000000') AS Strlp
FROM (((ItemActivity inner join Customer on ItemActivity.lngCustomerID=Customer.lngCustomerID) inner join CustomerAddress on ItemActivity.lngCustomerAddressID=CustomerAddress.lngCustomerAddressID) inner join CustomerBank on ItemActivity.lngCustomerBankID=CustomerBank.lngCustomerBankID) INNER JOIN (((ItemActivityDetail INNER JOIN Item ON Item.lngItemID = ItemActivityDetail.lngItemID) INNER JOIN ItemUnit ON ItemUnit.lngUnitID=ItemActivityDetail.lngUnitID) LEFT JOIN Tax ON Tax.lngTaxID=ItemActivityDetail.lngTaxID) ON ItemActivity.lngActivityID = ItemActivityDetail.lngActivityID
WHERE ItemActivity.lngReceiptTypeID in (20) and ItemActivity.strInvoiceType='1'

czg1997

呵呵，数据库特性不同，不好转啊。像Access中的IIF函数，在SQL Server和Oracle中也只能用Case When语句代替， 字符串连接 SQL Server是+, Oracle是 || 。
还是自己去找找他们之间的不同吧

还好

应该没有现成的工具
自己转吧

snowtank

你可以试试这个工具
Intelligent Converters
很不错的:)

20度的风

谢谢，我试一下看看。

yeser

这个Intelligent Converters，我也试试去，正想着转呢。