Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert into 2 fields value of one field

423911Mar 13 2007 — edited Apr 4 2007
I am trying to separate this value into 2 different fields.

Select last_name from clients1;

will return

' Lopez Gonzalez'

What I am trying to do is put 'Lopez' in last_name_1 and 'Gonzalez' in last_name_2 of a table.

The query will be returning around 3000 last names.

Any help?
Thanks,

Comments

User_XPEES

Any comments please?

User_XPEES

any recommendations or comments please?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 2 2007
Added on Mar 13 2007
7 comments
4,222 views