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