...
2. Queries from Oracle forms:
--SOACOMP
select s.first_name, s.last_name
from tbvsp_sponsor s
where last_name like
'Smi%'
and id like '%';
Cost (dev): 4
Cost (test): 4
-- SOAIDEN
select spriden_pidm, spriden_id, spriden_first_name
from spriden
where spriden_id_type = 'S'
and spriden_last_name like 'Smi%'
and spriden_first_name like '%'
and spriden_id like '%';
Cost (dev): 7
Cost (test): 8
select spriden_pidm, spriden_first_name
from spriden
where spriden_id_type = 'S'
and spriden_last_name like '%'
and spriden_first_name like '%'
and spriden_id like '610562178';
Cost (dev): 4
Cost (test): 4
SELECT SPRIDEN_PIDM,SPRIDEN_ID,SPRIDEN_LAST_NAME,SPRIDEN_FIRST_NAME, SPRIDEN_MI
FROM SPRIDEN
WHERE SPRIDEN_LAST_CAPS LIKE 'JOH%'
AND SPRIDEN_CHANGE_IND IS NULL ORDER BY SPRIDEN_LAST_NAME, SPRIDEN_FIRST_NAME,SPRIDEN_MI;
Cost (dev): 8
Cost (test): 139
CSF Common Legacy Unit Tests
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_.LAST_NAME)=upper('Joh%')
Cost (dev): 11
Cost (test): 3617