当想要查询:
包含任意两组或多组字符串的查询
原来可以这么用! 很好 很强大!
==================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
原来可以这么用! 很好 很强大!
==================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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8494287/viewspace-1390574/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8494287/viewspace-1390574/