Home » Developer & Programmer » Forms » dividing a column "EMP_name" into "first_name", "last_name" columns of (Oracle 10g)
dividing a column "EMP_name" into "first_name", "last_name" columns of [message #441097] Thu, 28 January 2010 13:25 Go to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SUBSTR and INSTR.

Regards
Michel
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 Go to previous messageGo to next message
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.
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 Go to previous message
BlackSwan
Messages: 25036
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/
Previous Topic: Opening fmx files in separate form builder
Next Topic: Anything like spool?
Goto Forum:
  


Current Time: Sun Dec 04 10:32:01 CST 2016

Total time taken to generate the page: 0.04946 seconds