...
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:
...