oracle - CSV SQL: How to Achieve This? -

using hxtt text drivers run queries on csv file. csv has entries like:

uid        rights user1      yyyy user2      nnnn user3      ynyn user4      yynn 

each character in column b represent role corresponding user has on system. 'y' means has role , 'n' means no. roles not referenced in csv , have hard code them. lets assume roles are:

1. first character = y means system admin
2. second character = y means developer
3. third character = y means dba
4. fourth character = y means user

the goal have query give result in separate rows if user has multiple roles. taking data table above, result should like:

uid     rights   role user1   yyyy     system admin user1   yyyy     developer user1   yyyy     dba user1   yyyy     user user2   nnnn     no role user3   ynyn     system admin user3   ynyn     dba 

and on. of oracle sql queries work using text driver , many don't. still understand how achieve this.