Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sql Code to Find Something

Sql Code to Find Something

From: Steve <schen_at_prodigy.net>
Date: 14 Mar 2003 14:15:26 -0800
Message-ID: <b166c214.0303141415.2c7a0b2d@posting.google.com> 





Anyone if interested:



How to extract those email address entries without @ sign?



Example:



table name:   emx_table


column_name:  email_addr



records like:   xxx_at_abc.com

                xxxabc.com





While email addresses have no pattern and record counts are thousands,
so you cannot specify the xxxabc.com, etc..



Appreciated.



Steve
Received on Fri Mar 14 2003 - 16:15:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US