2 Replies Latest reply: Aug 2, 2012 9:56 AM by Helios-GunesEROL RSS

    Upgrade 11.2.0.1 to 11.2.0.2

    723270
      Hi,

      I recently upgraded my oracle software from 11.2.0.1 to 11.2.0.2 sucessfully. But I got problem with sql code(search criteria), The same code is working on my previous version but in New version. Please look at the below code:

      SELECT DISTINCT BM.BO_CODE F1,
      BM.FIRST_NAME F2,
      BM.LAST_NAME F3,
      BBA.ABA_CODE F4,
      BBA.BANK_ACNT_NUM F5,
      BM.SSN F6,
      BAQ.APP_NO F7,
      BAQ.LOAN_TYPE F8,
      BAQ.APP_DATE F9
      FROM BO_MASTER BM,
      BO_IN_APP_QUEUE BAQ,
      BO_BANK_ACNT BBA
      WHERE BAQ.BO_CODE =BM.BO_CODE
      AND BAQ.BO_CODE =BBA.BO_CODE
      AND BM.BO_CODE =BBA.BO_CODE
      AND BM.IS_INTERNET='Y'
      AND ((UPPER(BM.LAST_NAME) LIKE 'RAY%' )
      OR (UPPER(BM.LAST_NAME) LIKE 'RAY%'))
      ORDER BY UPPER(BM.LAST_NAME),
      UPPER(BM.FIRST_NAME)

      My question is,
      1) Is there any code standards changed from 11.2.0.1 to 11.2.0.2??

      Thanks & Regards,
      LakshmikanthE.