we can do it in the following way
Imagine you have a table name gender that has name and gender column.
create a table gendernew like create table gendernew as
select * from(select name, R||S as...