select int_type_s || ' ' || int_type_v as intt
from ims_md_educational
where ims_md_id = :ims_md_id
select lrt_s || ' ' || lrt_v as lrt
from ims_md_educational_lrt
where ims_md_id = :ims_md_id
select int_level_s || ' ' || int_level_v as intl
from ims_md_educational
where ims_md_id = :ims_md_id
select sem_density_s || ' ' || sem_density_v as semd
from ims_md_educational
where ims_md_id = :ims_md_id
select ieur_s || ' ' || ieur_v as ieur
from ims_md_educational_ieur
where ims_md_id = :ims_md_id
select context_s || ' ' || context_v as context
from ims_md_educational_context
where ims_md_id = :ims_md_id
select tar_l || ' ' || tar_s as tar
from ims_md_educational_tar
where ims_md_id = :ims_md_id
select difficulty_s || ' ' || difficulty_v as diff
from ims_md_educational
where ims_md_id = :ims_md_id
select type_lrn_time as tlt,
type_lrn_time_l || ' ' || type_lrn_time_s as tlt_ls
from ims_md_educational
where ims_md_id = :ims_md_id
select descrip_l || ' ' || descrip_s as desc
from ims_md_educational_descrip
where ims_md_id = :ims_md_id
select language
from ims_md_educational_lang
where ims_md_id = :ims_md_id