The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'TRUE'
FROM sys.dual
WHERE EXISTS
(SELECT 1
FROM dba_policies
WHERE object_owner = UPPER(xp_object_schema)
AND object_name = UPPER(xp_object_name)
AND policy_name = UPPER(xp_policy_name)
);
'SELECT, INSERT, UPDATE, DELETE',
TRUE,
TRUE,
FALSE,
DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
'SELECT, INSERT, UPDATE, DELETE',
TRUE,
TRUE,
FALSE,
DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
'SELECT, INSERT, UPDATE, DELETE',
TRUE,
TRUE,
FALSE,
DBMS_RLS.SHARED_CONTEXT_SENSITIVE);
'SELECT, INSERT, UPDATE, DELETE',
TRUE,
TRUE,
FALSE,
DBMS_RLS.SHARED_CONTEXT_SENSITIVE);