正则表达

1、java demo
public static void main(String[] args){
String line = “OSS_This order was placed for QT3000! OK?”;
String pattern = “^(OSA_|OSS_)(.*)”;

	// 创建 Pattern 对象
	Pattern r = Pattern.compile(pattern);

	// 现在创建 matcher 对象
	Matcher m = r.matcher(line);
	if (m.find( )) {
		System.out.println("yeah, find!");
	}else{
		System.out.println("no find");
	}


}

2、https://www.runoob.com/regexp/regexp-syntax.html 正则表达式教程

3、例子
select a.terminal, regexp_substr(a.terminal, ‘(IIP|MIP):=[^0-9a-zA-Z]’,1,1,‘i’,1)
from ods.trd_entrust a where a.oc_date = 20200716;