Shulou(Shulou.com)05/31 Report--

This article mainly explains "oracle precise query and fuzzy query example code", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "oracle accurate query and fuzzy query example code"!

Precise query:

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

Fuzzy query:

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

At this point, I believe you have a deeper understanding of "oracle precise query and fuzzy query instance code". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.