Topic: Check the user regexp_like
Prompt how correctly to solve such task:
The irrelevant user, having an e-mail annak@ is underlined as the receiver of the documents which real receiver is an e-mail jannak@
email_cb Is a list of all addresses of receivers of the document (a type text box )
osname - the user name, can be other combination of user name further
select * from email, empl
where upper (email.email_cb) like ' % ' || upper (trim (empl.osname)) || ' ' || ' %'
Whether in line with all email_cb to check up is before osname gaps, punctuation signs (; ")
regexp_like (upper (email.email_cb), ' [^ [:space:] [:punct:]] ')
It is possible to solve it with the help expressions? How correctly to write down it?