Roles Privileges by Single Query?

Easy to do. This example is just for DBA:

select * from role_sys_privs

where role = 'DBA'

Results:

ROLE	PRIVILEGE	ADMIN_OPTION
DBA	CREATE SESSION	YES
DBA	ALTER SESSION	YES
DBA	DROP TABLESPACE	YES
DBA	BECOME USER	YES
DBA	DROP ROLLBACK SEGMENT	YES
DBA	SELECT ANY TABLE	YES
DBA	INSERT ANY TABLE	YES
DBA	UPDATE ANY TABLE	YES
DBA	DROP ANY INDEX	YES
DBA	SELECT ANY SEQUENCE	YES
DBA	CREATE ROLE	YES
DBA	EXECUTE ANY PROCEDURE	YES
DBA	ALTER PROFILE	YES
DBA	CREATE ANY DIRECTORY	YES
DBA	CREATE ANY LIBRARY	YES
DBA	EXECUTE ANY LIBRARY	YES
DBA	ALTER ANY INDEXTYPE	YES
DBA	DROP ANY INDEXTYPE	YES
DBA	DEQUEUE ANY QUEUE	YES
DBA	EXECUTE ANY EVALUATION CONTEXT	YES
DBA	EXPORT FULL DATABASE	YES
DBA	CREATE RULE	YES
DBA	ALTER ANY SQL PROFILE	YES
DBA	ADMINISTER ANY SQL TUNING SET	YES
DBA	CHANGE NOTIFICATION	YES
DBA	DROP ANY EDITION	YES
DBA	DROP ANY MINING MODEL	YES
DBA	ALTER ANY MINING MODEL	YES
DBA	ALTER ANY CUBE DIMENSION	YES
DBA	CREATE CUBE	YES
DBA	DROP ANY CUBE BUILD PROCESS	YES
DBA	ALTER ROLLBACK SEGMENT	YES
DBA	DELETE ANY TABLE	YES
DBA	ALTER DATABASE	YES
DBA	FORCE ANY TRANSACTION	YES
DBA	ALTER ANY PROCEDURE	YES
DBA	DROP ANY TRIGGER	YES
DBA	DROP ANY MATERIALIZED VIEW	YES
DBA	UNDER ANY TYPE	YES
DBA	ALTER ANY LIBRARY	YES
DBA	CREATE DIMENSION	YES
DBA	DEBUG ANY PROCEDURE	YES
DBA	CREATE RULE SET	YES
DBA	ALTER ANY RULE SET	YES
DBA	ANALYZE ANY DICTIONARY	YES
DBA	ALTER ANY EDITION	YES
DBA	CREATE ANY ASSEMBLY	YES
DBA	ALTER ANY CUBE	YES
DBA	SELECT ANY CUBE	YES
DBA	DROP ANY MEASURE FOLDER	YES
DBA	RESTRICTED SESSION	YES
DBA	CREATE TABLESPACE	YES
DBA	ALTER TABLESPACE	YES
DBA	CREATE USER	YES
DBA	ALTER USER	YES
DBA	LOCK ANY TABLE	YES
DBA	CREATE VIEW	YES
DBA	DROP ANY VIEW	YES
DBA	GRANT ANY ROLE	YES
DBA	CREATE TRIGGER	YES
DBA	CREATE TYPE	YES
DBA	EXECUTE ANY OPERATOR	YES
DBA	CREATE ANY DIMENSION	YES
DBA	ALTER ANY DIMENSION	YES
DBA	CREATE ANY OUTLINE	YES
DBA	ADMINISTER DATABASE TRIGGER	YES
DBA	RESUMABLE	YES
DBA	FLASHBACK ANY TABLE	YES
DBA	CREATE ANY RULE SET	YES
DBA	EXECUTE ANY RULE SET	YES
DBA	IMPORT FULL DATABASE	YES
DBA	EXECUTE ANY RULE	YES
DBA	EXECUTE ANY PROGRAM	YES
DBA	CREATE ANY EDITION	YES
DBA	CREATE ASSEMBLY	YES
DBA	ALTER ANY ASSEMBLY	YES
DBA	CREATE CUBE DIMENSION	YES
DBA	CREATE ANY CUBE BUILD PROCESS	YES
DBA	UPDATE ANY CUBE DIMENSION	YES
DBA	CREATE ANY TABLE	YES
DBA	CREATE ANY INDEX	YES
DBA	CREATE ANY SEQUENCE	YES
DBA	ALTER ANY ROLE	YES
DBA	ANALYZE ANY	YES
DBA	DROP ANY LIBRARY	YES
DBA	CREATE ANY OPERATOR	YES
DBA	CREATE INDEXTYPE	YES
DBA	UNDER ANY TABLE	YES
DBA	DROP ANY DIMENSION	YES
DBA	SELECT ANY DICTIONARY	YES
DBA	GRANT ANY OBJECT PRIVILEGE	YES
DBA	CREATE EVALUATION CONTEXT	YES
DBA	CREATE ANY EVALUATION CONTEXT	YES
DBA	DROP ANY EVALUATION CONTEXT	YES
DBA	CREATE ANY RULE	YES
DBA	CREATE JOB	YES
DBA	CREATE ANY JOB	YES
DBA	CREATE MINING MODEL	YES
DBA	INSERT ANY CUBE DIMENSION	YES
DBA	DROP ANY CUBE	YES
DBA	UPDATE ANY CUBE BUILD PROCESS	YES
DBA	ALTER SYSTEM	YES
DBA	AUDIT SYSTEM	YES
DBA	UNLIMITED TABLESPACE	YES
DBA	CREATE ROLLBACK SEGMENT	YES
DBA	DROP ANY TABLE	YES
DBA	COMMENT ANY TABLE	YES
DBA	CREATE CLUSTER	YES
DBA	ALTER ANY INDEX	YES
DBA	DROP PUBLIC DATABASE LINK	YES
DBA	CREATE PROFILE	YES
DBA	ALTER ANY MATERIALIZED VIEW	YES
DBA	ALTER ANY TYPE	YES
DBA	DROP ANY TYPE	YES
DBA	UNDER ANY VIEW	YES
DBA	EXECUTE ANY INDEXTYPE	YES
DBA	DROP ANY CONTEXT	YES
DBA	ALTER ANY OUTLINE	YES
DBA	ADMINISTER RESOURCE MANAGER	YES
DBA	MANAGE SCHEDULER	YES
DBA	MANAGE FILE GROUP	YES
DBA	CREATE ANY MINING MODEL	YES
DBA	SELECT ANY MINING MODEL	YES
DBA	CREATE ANY MEASURE FOLDER	YES
DBA	DELETE ANY MEASURE FOLDER	YES
DBA	CREATE TABLE	YES
DBA	BACKUP ANY TABLE	YES
DBA	CREATE ANY CLUSTER	YES
DBA	DROP ANY SYNONYM	YES
DBA	DROP PUBLIC SYNONYM	YES
DBA	CREATE ANY VIEW	YES
DBA	CREATE SEQUENCE	YES
DBA	ALTER ANY SEQUENCE	YES
DBA	FORCE TRANSACTION	YES
DBA	CREATE PROCEDURE	YES
DBA	CREATE ANY PROCEDURE	YES
DBA	ALTER RESOURCE COST	YES
DBA	DROP ANY DIRECTORY	YES
DBA	CREATE ANY TYPE	YES
DBA	ALTER ANY OPERATOR	YES
DBA	CREATE ANY INDEXTYPE	YES
DBA	ENQUEUE ANY QUEUE	YES
DBA	ON COMMIT REFRESH	YES
DBA	DEBUG CONNECT SESSION	YES
DBA	DROP ANY RULE SET	YES
DBA	EXECUTE ANY CLASS	YES
DBA	MANAGE ANY FILE GROUP	YES
DBA	EXECUTE ANY ASSEMBLY	YES
DBA	EXECUTE ASSEMBLY	YES
DBA	COMMENT ANY MINING MODEL	YES
DBA	CREATE ANY CUBE DIMENSION	YES
DBA	DELETE ANY CUBE DIMENSION	YES
DBA	SELECT ANY CUBE DIMENSION	YES
DBA	ALTER ANY TABLE	YES
DBA	DROP ANY CLUSTER	YES
DBA	CREATE SYNONYM	YES
DBA	CREATE PUBLIC SYNONYM	YES
DBA	DROP ANY SEQUENCE	YES
DBA	DROP ANY ROLE	YES
DBA	AUDIT ANY	YES
DBA	DROP ANY PROCEDURE	YES
DBA	CREATE ANY TRIGGER	YES
DBA	ALTER ANY TRIGGER	YES
DBA	DROP PROFILE	YES
DBA	GRANT ANY PRIVILEGE	YES
DBA	CREATE LIBRARY	YES
DBA	CREATE OPERATOR	YES
DBA	DROP ANY OUTLINE	YES
DBA	MERGE ANY VIEW	YES
DBA	ADMINISTER SQL TUNING SET	YES
DBA	UPDATE ANY CUBE	YES
DBA	INSERT ANY MEASURE FOLDER	YES
DBA	ADMINISTER SQL MANAGEMENT OBJECT	YES
DBA	MANAGE TABLESPACE	YES
DBA	DROP USER	YES
DBA	ALTER ANY CLUSTER	YES
DBA	CREATE ANY SYNONYM	YES
DBA	CREATE DATABASE LINK	YES
DBA	CREATE PUBLIC DATABASE LINK	YES
DBA	CREATE MATERIALIZED VIEW	YES
DBA	CREATE ANY MATERIALIZED VIEW	YES
DBA	EXECUTE ANY TYPE	YES
DBA	DROP ANY OPERATOR	YES
DBA	QUERY REWRITE	YES
DBA	GLOBAL QUERY REWRITE	YES
DBA	MANAGE ANY QUEUE	YES
DBA	CREATE ANY CONTEXT	YES
DBA	ALTER ANY EVALUATION CONTEXT	YES
DBA	ALTER ANY RULE	YES
DBA	DROP ANY RULE	YES
DBA	ADVISOR	YES
DBA	SELECT ANY TRANSACTION	YES
DBA	DROP ANY SQL PROFILE	YES
DBA	CREATE ANY SQL PROFILE	YES
DBA	READ ANY FILE GROUP	YES
DBA	CREATE EXTERNAL JOB	YES
DBA	DROP ANY ASSEMBLY	YES
DBA	DROP ANY CUBE DIMENSION	YES
DBA	CREATE ANY CUBE	YES
DBA	CREATE MEASURE FOLDER	YES
DBA	CREATE CUBE BUILD PROCESS	YES
DBA	FLASHBACK ARCHIVE ADMINISTER	YES