OraFAQ Forum: SQL & PL/SQL » SELECT email address and only display username Array? Delimiter?

Home » SQL & PL/SQL » SQL & PL/SQL » SELECT email address and only display username Array? Delimiter?

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

SELECT email address and only display username Array? Delimiter? [message #272634]

Fri, 05 October 2007 14:42

hdogg
Messages: 94
Registered: March 2007

Member

Table Users:
ID,Email, Username, Password

USERNAME@email.com

I want to select the EMAIL field and select only the USERNAME, and put it into Username.

Hence I need to parse the email address and use the @ as the delimiter.

Any Ideas?

Report message to a moderator

Re: SELECT email address and only display username Array? Delimiter? [message #272635 is a reply to message #272634]

Fri, 05 October 2007 14:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

substr,instr

Regards
Michel

Report message to a moderator

Re: SELECT email address and only display username Array? Delimiter? [message #272641 is a reply to message #272634]

Fri, 05 October 2007 14:59

hdogg
Messages: 94
Registered: March 2007

Member

Thank you!

I went ahead and looked the SUBSTR and INSTR functions up at and found this link:

http://www.psoug.org/reference/substr_instr.html

This is how to return the username:

SELECT SUBSTR('yourname@email.com', 1 ,INSTR('yourname@email.com', '@', 1, 1)-1)
FROM dual;

Report message to a moderator

Re: SELECT email address and only display username Array? Delimiter? [message #272642 is a reply to message #272641]

Fri, 05 October 2007 15:05

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.
Michel

Report message to a moderator

Previous Topic:	Converting SQL from MSSQL to ORACLE
Next Topic:	value returned from a function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 12:57:51 CST 2024