The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page Sorry question on SQL
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Sorry question on SQL
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 10-02-2006
dsravan dsravan is offline
Registered User
  
 

Join Date: Jul 2006
Posts: 188
Sorry question on SQL
Experts,

I need small help in oracle. I am just putting this question here because i think there are SQL geniuses here as well as UNIX.

I have a string that contains the First name, Middle name and last name in one field in the table in Oracle. I need to extract each one of them seperately. Can any one help with sql for this please.

Field in the table
Quote:
e.g Jody E Mcquire
Required Output:
Quote:
Jody
E
Mcquire
I will appreciate help in this matter.

Thanks