Separate from Comma

Hi all.

Is there a way to separate an oracle db field that contains
such info:

LastName,FirstName or FirstName Lastname into Lastname,
Firstname using toad not a function or stored proc.

James,Aaron or Aaron James into James, Aaron (not there is a
space btw last and first name)

Thanks...



Separate from Comma
I seem to recall posting an answer to a similar question with
some Oracle functions that you could use to solve this problem too
(unless there is some reason why you wish to use an Oracle database
without learning anything about Oracle).



SUBSTR() and INSTR() are your friends, among others....



PhilSeparate from Comma
You are right .. My bad....I feel lazy
sometime...sorry...Thanks.