SQL Language (MOSC)

MOSC Banner

Sql query

edited Jan 21, 2013 1:42AM in SQL Language (MOSC) 6 commentsAnswered ✓
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center