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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69949806/viewspace-2664729/ ，如需转载，请注明出处，否则将追究法律责任。
