oracle 精确查询和模糊查询

精确查询： SELECT  d.ACCOUNT_ as ACCOUNT_,   t.ID_,t.NAME_,t.PROFILE_,t.STATUS_,t.GENDER_,t.EMAIL_,t.ADDRESS_,t.MOBILE_,t.QQ_,t.WC_ACCOUNT_,t.PHOTO_,t.POSITIONS_,t.GROUP_ID_,t.CREATE_TIME_,t.UPDATE_TIME_,t.ORGID        FROM IBPS_PARTY_EMPLOYEE t LEFT JOIN Ibps_Party_User d ON  t.ID_ =d.ID_          WHERE GENDER_ = 'male'     ORDER BY ID_ DESC 模糊查询： SELECT  d.ACCOUNT_ as ACCOUNT_,   t.ID_,t.NAME_,t.PROFILE_,t.STATUS_,t.GENDER_,t.EMAIL_,t.ADDRESS_,t.MOBILE_,t.QQ_,t.WC_ACCOUNT_,t.PHOTO_,t.POSITIONS_,t.GROUP_ID_,t.CREATE_TIME_,t.UPDATE_TIME_,t.ORGID        FROM IBPS_PARTY_EMPLOYEE t LEFT JOIN Ibps_Party_User d ON  t.ID_ =d.ID_          WHERE GENDER_ like  '%male%'     ORDER BY ID_ DESC