I want to insert the below 4 records in single sql statement, how can I do that?
name empid role
------- --------- -----
abc 123 sqldeveloper
abc 123 plsqldeveloper
abc 123 teamlead
Third column must be changed and first two columns are same, I need to assign 3 roles to same person is like composite primary key.
Please guide me here, Thanks in advance.