Sql query
Hi,i am having a sample data like below
create table test_names (
name varchar2(100)
)
insert into test_names (name) values ('JONES, BOB');
insert into test_names (name) values ('JOHNSON,MIKE');
insert into test_names (name) values ('SMITH, MARY ANN');
insert into test_names (name) values ('PIERRI-CARLSON, CHRISTEN');
insert into test_names (name) values ('SUZY SMITHSON');
insert into test_names (name) values ('MARK SANTOSH');
select name from test_names
--result
JONES, BOB
JOHNSON,MIKE
SMITH, MARY ANN
PIERRI-CARLSON, CHRISTEN
SUZY SMITHSON
MARK SANTOSH
need to look like
BOB JONES
MIKE JOHNSON
MARY ANN SMITH
CHRISTEN PIERRI-CARLSON
SMITHSON SUZY
SANTOSH MARK
name varchar2(100)
)
insert into test_names (name) values ('JONES, BOB');
insert into test_names (name) values ('JOHNSON,MIKE');
insert into test_names (name) values ('SMITH, MARY ANN');
insert into test_names (name) values ('PIERRI-CARLSON, CHRISTEN');
insert into test_names (name) values ('SUZY SMITHSON');
insert into test_names (name) values ('MARK SANTOSH');
select name from test_names
--result
JONES, BOB
JOHNSON,MIKE
SMITH, MARY ANN
PIERRI-CARLSON, CHRISTEN
SUZY SMITHSON
MARK SANTOSH
need to look like
BOB JONES
MIKE JOHNSON
MARY ANN SMITH
CHRISTEN PIERRI-CARLSON
SMITHSON SUZY
SANTOSH MARK
0