當想要查詢：包含任意兩組或多組字串的查詢

原來可以這麼用！很好很強大！
==================table_name like '%DBA%PRIVS%'==LIKE的經典用法============
select * from dictionary
where table_name like '%DBA%PRIVS%'

TABLE_NAME COMMENTS
=====================================================
1 DBA_AQ_AGENT_PRIVS
2 DBA_COL_PRIVS All grants on columns in the database
3 DBA_ROLE_PRIVS Roles granted to users and roles
4 DBA_RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups
5 DBA_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager
6 DBA_SYS_PRIVS System privileges granted to users and roles
7 DBA_TAB_PRIVS All grants on objects in the database

like查詢含任意多組字串方法--很好很強大

相關文章