...
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)=upper('Ale%')
select
| No Format |
|---|
Cost (dev): 13
Cost (test): 3617
|
select
student0_.PIDM as PIDM41_,
...
SPV_STUDENT_VIEW student0_
where
(
upper(student0_.FIRST_NAME) like upper('An%')
)
and (
upper(student0_.LAST_NAME) =like upper('Ale%*ohansson')
)
| No Format |
|---|
Cost (dev): 133 Cost (test): 3617 2283 |
...
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:
...