当前位置: 代码迷 >> Oracle管理 >> sql server数据迁移到oracl时出现的有关问题
  详细解决方案

sql server数据迁移到oracl时出现的有关问题

热度:112   发布时间:2016-04-24 06:11:46.0
sql server数据迁移到oracl时出现的问题
现在sql   server   中一视图如下:


CREATE   VIEW   dbo.V_BUY_ENQUIRY_REPORT
AS
SELECT   TOP   100   PERCENT   dbo.TB_BASE_COMPANY.vcAllName,  
            dbo.TB_BUY_ENQUIRY.vcEnquiryCode,  
            dbo.TB_BUY_ENQUIRY_ITEM.vcGoodsCode,  
            dbo.TB_BUY_ENQUIRY_ITEM.vcGoodsName,  
            dbo.TB_BUY_ENQUIRY_ITEM.vcGoodsSize,   dbo.TB_BUY_ENQUIRY_ITEM.fNumber,  
            dbo.TB_BUY_ENQUIRY_ITEM.vcMainUnit,   dbo.TB_BUY_ENQUIRY_ITEM.fPrice,  
            dbo.TB_BUY_ENQUIRY_ITEM.fTotalPrice,   dbo.TB_BUY_ENQUIRY.vcMoneyCode,  
            dbo.TB_BUY_ENQUIRY.vcDeptName,   dbo.TB_ORG_PERSON.vcPersonName,  
            dbo.TB_BUY_ENQUIRY.vcStatus,   dbo.TB_BUY_ENQUIRY.dCreateDate,  
            dbo.TB_BUY_ENQUIRY_ITEM.vcAspID
FROM   dbo.TB_BUY_ENQUIRY   LEFT   OUTER   JOIN
            dbo.TB_BASE_COMPANY   ON  
            dbo.TB_BUY_ENQUIRY.vcAspID   =   dbo.TB_BASE_COMPANY.vcAspID   AND  
            dbo.TB_BUY_ENQUIRY.vcCompID   =   dbo.TB_BASE_COMPANY.vcCompID   LEFT   OUTER
              JOIN
            dbo.TB_ORG_PERSON   ON  
            dbo.TB_BUY_ENQUIRY.vcEnquiry   =   dbo.TB_ORG_PERSON.vcPersonCode   AND  
            dbo.TB_BUY_ENQUIRY.vcAspID   =   dbo.TB_ORG_PERSON.vcAspID   LEFT   OUTER   JOIN
            dbo.TB_BUY_ENQUIRY_ITEM   ON  
            dbo.TB_BUY_ENQUIRY.vcEnquiryID   =   dbo.TB_BUY_ENQUIRY_ITEM.vcEnquiryID
ORDER   BY   dbo.TB_BUY_ENQUIRY.dCreateDate   DESC
我在orcal中创建其对应的视图为:
SELECT   TOP   100   PERCENT   TOYERP.TB_BASE_COMPANY.vcAllName,  
            TOYERP.TB_BUY_ENQUIRY.vcEnquiryCode,  
            TOYERP.TB_BUY_ENQUIRY_ITEM.vcGoodsCode,  
            TOYERP.TB_BUY_ENQUIRY_ITEM.vcGoodsName,  
            TOYERP.TB_BUY_ENQUIRY_ITEM.vcGoodsSize,   TOYERP.TB_BUY_ENQUIRY_ITEM.fNumber,  
            TOYERP.TB_BUY_ENQUIRY_ITEM.vcMainUnit,   TOYERP.TB_BUY_ENQUIRY_ITEM.fPrice,  
            TOYERP.TB_BUY_ENQUIRY_ITEM.fTotalPrice,   TOYERP.TB_BUY_ENQUIRY.vcMoneyCode,  
            TOYERP.TB_BUY_ENQUIRY.vcDeptName,   TOYERP.TB_ORG_PERSON.vcPersonName,  
            TOYERP.TB_BUY_ENQUIRY.vcStatus,   TOYERP.TB_BUY_ENQUIRY.dCreateDate,  
            TOYERP.TB_BUY_ENQUIRY_ITEM.vcAspID
FROM   TOYERP.TB_BUY_ENQUIRY   LEFT   OUTER   JOIN
            TOYERP.TB_BASE_COMPANY   ON  
            TOYERP.TB_BUY_ENQUIRY.vcAspID   =   TOYERP.TB_BASE_COMPANY.vcAspID   AND  
  相关解决方案