select certain character in the column
Posted by:
Yi Ling
Date: November 01, 2004 08:25PM
i have 3 columns in the tables --> Company, name, email
if i want to retrieve the domain name of the company.......
e.g. company name email
Ang Mo Kio abc
abc@angmokio.com
Ang Mo Kio xyz
xyz@angmokio.com
Ang Mo Kio who
who@angmokio.com.sg
how can i check for the email.. and just retrieve the word after '@' (domain name) ???
any help is muchly appreciated...
Subject
Written By
Posted
select certain character in the column
November 01, 2004 08:25PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.