当想要查询：包含任意两组或多组字符串的查询
原来可以这么用！ 很好 很强大！
==================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博客 ” ，链接：https://blog.itpub.net/8494287/viewspace-1390574/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
sshd_config参数说明
下一篇：
小议物化视图与基表数据不一致的消除（四）
请登录后发表评论
登录
全部评论
