Home » SQL & PL/SQL » SQL & PL/SQL » devide a full name of a person into 4 seperate names
devide a full name of a person into 4 seperate names [message #202977] Mon, 13 November 2006 08:09 Go to next message
ramzi_j_h
Messages: 36
Registered: September 2006
Location: Jordan
Member
Hi
i want SQL statement to devide a name of a person for example into 3 or 4 seperate names

like this

"John peter smith"

into

"John"
"peter"
"smith"

thanks alot in advance
Re: devide a full name of a person into 4 seperate names [message #202981 is a reply to message #202977] Mon, 13 November 2006 08:14 Go to previous messageGo to next message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
Use substr and instr....

By
Vamsi
Re: devide a full name of a person into 4 seperate names [message #203045 is a reply to message #202981] Mon, 13 November 2006 12:35 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.orafaq.net/msgboard/newbies/messages/5337.htm
http://www.quest-pipelines.com/newsletter-v3/0602_B.htm
Previous Topic: Keep .doc in Database
Next Topic: ORA-25000 invalid use of bind variable in trigger WHEN clause
Goto Forum:
  


Current Time: Sun Jun 25 12:31:46 CDT 2017

Total time taken to generate the page: 0.20473 seconds