Child pages
  • Oracle Data Integrator Design Repository Metadata

Versions Compared

Key

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

...

Code Block
languagesql
select s.scen_name, s.scen_version, t.task_name1, t.task_name2,t.def_txt, s.last_date 
from ODIxxxBI_ODI_REPO.snp_scen s 
join ODIxxxBI_ODI_REPO.snp_scen_task t on t.scen_no = s.scen_no
where s.scen_name like '%F_KON%%MAPPINGNAME%' 
order by t.SCEN_TASK_NO;

...