select t1.resume_Id,
t1.real_name,
t1.phone,
t1.gender,
t2.gender_desc, --性别
to_char(t1.apply_date, 'yyyy-mm-dd hh24:mi') apply_date,
to_char(t1.reserve_date, 'yyyy-mm-dd hh24:mi') reserve_date,
t1.apply_posts,
t3.position_desc as apply_postsName, --面试岗位
t4.place_name as reserve_placeName, --面试地址
t5.status_desc, --面试情况
t6.education_desc, --学历
to_char(t1.graduate_date, 'yyyy-MM-dd') graduate_date,
t1.graduated_university,
t1.description,
t1.major
from T_RESUME t1,
T_BASIC_GENDER t2,
T_BASIC_POSITION t3,
T_BASIC_RESERVE_PLACE t4,
T_BASIC_RECRUIT_STATUS t5,
T_BASIC_EDUCATION t6
where t1.education = t6.education_id(+)
and t1.status = t5.status_id(+)
and t1.reserve_place = t4.place_id(+)
and t1.apply_posts = t3.position_id(+)
and t1.gender = t2.gender_id(+)
大概数据有2000-3000++后期还会增加,想提高查询速度!!!
t1.real_name,
t1.phone,
t1.gender,
t2.gender_desc, --性别
to_char(t1.apply_date, 'yyyy-mm-dd hh24:mi') apply_date,
to_char(t1.reserve_date, 'yyyy-mm-dd hh24:mi') reserve_date,
t1.apply_posts,
t3.position_desc as apply_postsName, --面试岗位
t4.place_name as reserve_placeName, --面试地址
t5.status_desc, --面试情况
t6.education_desc, --学历
to_char(t1.graduate_date, 'yyyy-MM-dd') graduate_date,
t1.graduated_university,
t1.description,
t1.major
from T_RESUME t1,
T_BASIC_GENDER t2,
T_BASIC_POSITION t3,
T_BASIC_RESERVE_PLACE t4,
T_BASIC_RECRUIT_STATUS t5,
T_BASIC_EDUCATION t6
where t1.education = t6.education_id(+)
and t1.status = t5.status_id(+)
and t1.reserve_place = t4.place_id(+)
and t1.apply_posts = t3.position_id(+)
and t1.gender = t2.gender_id(+)
大概数据有2000-3000++后期还会增加,想提高查询速度!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货