Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
Cost (dev): 3
Cost (test): 2283
Code Block

select
        student0_.PIDM as PIDM41_,
        student0_.MIT_ID as MIT2_41_,
        student0_.LAST_NAME as LAST3_41_,
        student0_.FIRST_NAME as FIRST4_41_,
        student0_.MIDDLE_NAME as MIDDLE5_41_,
        student0_.SEX as SEX41_,
        student0_.CITIZENSHIP as CITIZENS7_41_,
        student0_.BIRTH_DATE as BIRTH8_41_,
        student0_.KRB_NAME as KRB9_41_
     from        SPV_STUDENT_VIEW student0_
     where        (            upper(student0_.FIRST_NAME) like upper('An%')        )
         and (            upper(student0_.LAST_NAME) like upper('*ohansson')        )
2. Queries from Oracle forms:

...