SQL & PL/SQL

Hi

I have a names table and need to scramble first name and last name. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production.

with names as

(select 'LISA OBRIEN' name from dual

union

select 'GRETCHEN ALIX' name from dual

union

select 'SANDRA HURLEY-SHOAF' name from dual

union

select 'JENNY PLUNKETT-KRUSE' name from dual

union

select 'MELODY STALEY' name from dual

union

select 'DYON AYYAPPAN' name from dual

union

select 'MICHAEL BUENO' name from dual

union

select 'SANDRA ELLISON' name from dual

union

select 'KEVIN RADSKE' name from dual)

select * from names

Need a output with first last names scrambled in any order. Thanks for your help.

NAME

--------

LISA ALIX

SANDRA BUENO

MELODY ELLISON

KEVIN STALEY

.....