sql - 使用 Regx 提取信息

Question

我试图提取几个关键词，特别是从附加的数据样本中。我想知道我是否可以使用 Oracle Regex 或一些高级自然语言函数（如果有的话）？

从随附的样本中。我需要从“注释”列中提取与先前实体的单个关联。以下是我需要的附加示例的输出。我有大约 6K 条这样的笔记。

 id Notes
 1  Mr. Stewart Little is a Co-Founder and serves as the Chief Information Officer at Rinco. He is the faculyt of Department of Computer Science at Kinteic Enginerring Universtity. He was the Director at Mercury Marine.
 2  Ms. Lindsy Grahm is a Co-Founder and serves as a Head of Design at Mercedes. Lindsy is a Forbes 30 Under 30 recipient, and most recently was a Co-Founder of Thrivent, an enterprise datacenter management platform started from a Harvard University research project.
 3  Mr. Michael Johnson is a Co-Founder and Board Member of RedTraffic, where he serves as Chief Executive Officer. He is a Co-Founder of Majesic Solutions. Prior to this, he co-founded Pride Systems. He also co-founded and was a Board Member of Excel Capital. He also served as Chief Operating Officer at the New York Times Publishing Corporation.
 4  Mr. Shawn Reiding is a Co-Founder and serves as the Chief Executive Officer at Captial Corp. He was also the Co-Founder and CTO at Rinco.
 5  Ms. Sheena Jackson is a Co-Founder and serves as the Chief Executive Officer at MightyTalk. Previously, she served as a Director, Product Management at Aero Network.

预期成绩

id Previous_Associations 
1  Mercury Marine
2  Thrivent
3  Pride System, Excel Capital
4  Rinco
5  Aero Network

标签： sqlpython-3.xoracle