OraFAQ Forum: SQL & PL/SQL » devide a full name of a person into 4 seperate names

Home » SQL & PL/SQL » SQL & PL/SQL » devide a full name of a person into 4 seperate names

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

devide a full name of a person into 4 seperate names [message #202977]

Mon, 13 November 2006 08:09

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

Report message to a moderator

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

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Use substr and instr....

By
Vamsi

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Keep .doc in Database
Next Topic:	ORA-25000 invalid use of bind variable in trigger WHEN clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 02:33:03 CDT 2024