profile option

Hello

I need query to compare all profile option value at site level and responsibility level and display the profile option name,site level value and responsibility value.

if responsibility level value are different from site level value.

set long 10000

set pagesize 500

set linesize 160

column SHORT_NAME format a30

column NAME format a40

column LEVEL_SET format a15

column CONTEXT format a30

column VALUE format a40

select p.profile_option_name SHORT_NAME,

n.user_profile_option_name NAME,

decode(v.level_id,

10001, \'Site\',

10002, \'Application\',

10003, \'Responsibility\',

10004, \'User\',

10005, \'Server\',

10006, \'Org\',

10007, decode(to_char(v.level_value2), \'-1\', \'Responsibility\',