Union of 4 different columns in Single Row [message #655212] |
Wed, 24 August 2016 23:06 |
anil_apps
Messages: 34 Registered: November 2005 Location: India
|
Member |
|
|
In one table (xx_priv_rol) with five columns of Char(1) with Value Y/N
privilage
EXP
IMP
RUN
VIW
ADN
USER_NAME
-- Below scripts are used
create table xx_priv_rol(privilage varchar2(100), EXP char(1),IMP char(1),RUN char(1), VIW char(1) ,ADN char(1), USER_NAME varchar2(15));
insert into xx_priv_rol values('role1','Y','N','Y','N','N','AAROHI');
insert into xxx_priv_rol values('role2','Y','Y','N','Y','Y','AAROHI');
insert into xx_priv_rol values('role3','Y','N','N','Y','N','AAROHI');
I want to get highest privilege for all role's in one row for one user
There can be n number of records with different role with same user
I am expecting below result
EXP|IMP|RUN|VIEW|ADN
--------------------
Y | Y | Y | Y | Y
how can I achieve this?
Please suggest
|
|
|
|
|
|
|