OraFAQ Forum: Forms » dividing a column "EMP_name" into "first_name", "last

Home » Developer & Programmer » Forms » dividing a column "EMP_name" into "first_name", "last_name" columns of (Oracle 10g)

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

dividing a column "EMP_name" into "first_name", "last_name" columns of [message #441097]

Thu, 28 January 2010 13:25

DBase482
Messages: 6
Registered: January 2010

Junior Member

Hello,

Here's my situation:

I have first and last name stored in the same column in this style: Philip Brown .How can I query it in such a way as to read the first and last names separately?

Thank you.

Report message to a moderator

Re: dividing a column "EMP_name" into "first_name", "last_name" column [message #441098 is a reply to message #441097]

Thu, 28 January 2010 13:35

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use SUBSTR and INSTR.

Regards
Michel

Report message to a moderator

Re: dividing a column "EMP_name" into "first_name", "last_name" column [message #441099 is a reply to message #441098]

Thu, 28 January 2010 13:47

DBase482
Messages: 6
Registered: January 2010

Junior Member

could you please show me how I would nest these two functions? I'm rather new at this.

Thank you.

Report message to a moderator

Re: dividing a column "EMP_name" into "first_name", "last_name" column [message #441100 is a reply to message #441099]

Thu, 28 January 2010 13:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/?SQ=12e0d395b2ac35b6da370aa476522e92&t=search&srch=substr+instr&btn_submit=Search&field=a ll&forum_limiter=1&search_logic=AND&sort_order=DESC&author=

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Previous Topic:	Opening fmx files in separate form builder
Next Topic:	Anything like spool?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:27:26 CDT 2024