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++后期还会增加,想提高查询速度!!!