SQL & PL/SQL

Hi All,

How to get the string before and after the character comma ( , )

Ex: The string contains value John,Kennedy

I need the output as first stirng - John

                              Second stirng - Kennedy

create table names (fullname varchar2(20));

insert into names values ('John,Kennedy');

insert into names values ('Rikin,Shan');

insert into names values ('Don,Bosco');

select * from names ;

Expected Output

fullname                 firstname  lastname

John,Kennedy         John         Kennedy

Rikin,Shan              Rikin         Shan

Don,Bosco              Don           Bosco

Please let me know how to do this

Thanks,