Home » SQL & PL/SQL » SQL & PL/SQL » Data Extraction (Oracle 12C)
Data Extraction [message #684465] Fri, 11 June 2021 09:30 Go to next message
Messages: 1
Registered: April 2021
Junior Member
Hi Team,
I am having a LOG_Comments column VARCHAR2(4000 BYTE), it contains mail ids, some random text with mail ids and numbers too
Am trying to query the rows which is having the email id and numbers
while using REG_EXP LIKE am getting the columns having only mail ids , but i need to get some random text with mail ids also

eg : I can able to retrieve 'xyz@abc.com' but not 'Replacement -need abc@ghncom,xyz@ghn.com'
please suggest your ideas
Re: Data Extraction [message #684466 is a reply to message #684465] Fri, 11 June 2021 10:43 Go to previous message
Michel Cadot
Messages: 67923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

With any SQL or PL/SQL question, please, post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Previous Topic: CHR(n) equivalent function for double-byte characters
Next Topic: Data masking in oracle
Goto Forum:

Current Time: Tue Aug 03 20:54:33 CDT 2021