Find an Oracle role SQL Code 1select * 2from dba_roles 3where role like '&role' 4/ Sample Oracle Output: 1 2no rows selected 3SQL> Purpose: This code retrieves information about a specific database role, based on a partial or complete role name provided by the user. Breakdown:
select *
:** This clause …
Read More