Write a query print all @ symbols? [Resolved]

Posted by Rajesh123 under Oracle on 8/19/2015 | Points: 10 | Views : 895 | Status : [Member] | Replies : 5
I have one email id like rajesh@gmail.com.like that i have 1000 email address?
i want all "@" symbols.

rajesh.plsql123@gmail.com


Responses

Posted by: Bandi on: 8/20/2015 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
do you have comma or semi colon separated email IDS?

If yes, first you split them into multiple records by splitting based on comma or semi colon
for splitting -- https://blogs.oracle.com/aramamoo/entry/how_to_split_comma_separated_string_and_pass_to_in_clause_of_select_statement

After that apply SUBSTRING function to extract string after @ symbol......


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajesh123 on: 8/20/2015 [Member] Starter | Points: 25

Up
0
Down
Hi bandi
can u put the query
that link is not open.

rajesh.plsql123@gmail.com

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajesh123 on: 8/20/2015 [Member] Starter | Points: 25

Up
0
Down
hi bandi
thanks for your response
CREATE TABLE MAILIDS(MAILID VARCHAR2(20));
INSERT INTO MAILIDS VALUES('&MAILID');

SELECT SUBSTR(MAILID,(INSTR(MAILID,'@')),1) FROM MAILIDS;

rajesh.plsql123@gmail.com

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 8/20/2015 [Member] [MVP] Platinum | Points: 25

Up
0
Down
https://blogs.oracle.com/aramamoo/entry/how_to_split_comma_separated_string_and_pass_to_in_clause_of_select_statement

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajesh123 on: 8/20/2015 [Member] Starter | Points: 25

Up
0
Down
hi bandi
your link is not open in my network..
k any way thank you.

rajesh.plsql123@gmail.com

Rajesh123, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response