Hi,
We are using Oracle 8i (Oracle8i Enterprise Edition Release *8.1.7.4.0 - 64bit Production*).
My requirement is -
I need output like
USER_NAME Company
Suri 01,86,65
Srinu 01,86,65
Here is the sample data.
WITH t AS ( SELECT 'SURI' user_name ,'01' Company FROM dual UNION ALL
SELECT 'SURI' user_name, '86' Company FROM dual UNION ALL
SELECT 'SURI' user_name ,'65' Company FROM dual UNION ALL
SELECT 'SRINU' user_name, '01' Company FROM dual UNION ALL
SELECT 'SRINU' user_name ,'86' Company FROM dual UNION ALL
SELECT 'SRINU' user_name ,'65' Company FROM dual )
SELECT * FROM t ;
USER_NAME COMPANY
SURI 01
SURI 86
SURI 65
SRINU 01
SRINU 86
SRINU 65
Many thanks in advance for the help.
Thanks,
Suri