Hi this is my main table..but this split in two table like below output tables.
How can i write the query please rply frds.
EMPLOYEE_PHONE
SSN (PK) NAME PHONES
123456789 Wiles, A. 1122334455, 3344556677, 6677889944
234567890 Newton, I. 3399118822, 3399554773
345678901 Turing, A 2266001993
456789012 Gauss, C.F. 4466577853
Output:1 EMPLOYEE_NAME
SSN (PK) NAME
123456789 Wiles, A.
234567890 Newton, I.
345678901 Turing, A
456789012 Gauss, C.F.
Output:2 EMPLOYEE_PHONE
SSN (PK) PHONES (PK)
123456789 1122334455
123456789 3344556677
123456789 6677889944
234567890 3399554773
234567890 3399118822
345678901 2266001993
456789012 4466577853
rajesh.plsql123@gmail.com