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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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: Thu Dec 08 19:55:02 CST 2016

Total time taken to generate the page: 0.08319 seconds