Oracle queries do not include parentheses and methods that do not contain the specified characters _oracle

An Oracle query without parentheses does not contain the specified characters in a record method as follows:

 With tmp_t as (
 Select 1 as ID, ' Test 4321_cs ' as name from dual UNION ALL
 Select 2, ' Test 1200 (Beta) ' from dual Union all<  C3/>select 3, ' Test 123 (Beta) ' from dual union ALL
 Select 4, ' Test 1212 (D2) ' from dual union ALL
 Select 5, ' Test 1212 (D2) Beta ' From dual UNION ALL
 Select 6, ' Test 123 ' from dual '
 select *
  from tmp_t
 where InStr (name, ' _cs ') = 0
  D regexp_instr (Name, ' (. *) ') = 0 and
  regexp_instr (name, ' (. *\) ') = 0

The results are:

Where Regexp_instr is a regular expression function supported by Oracle, it functions like instr. The records that contain parentheses () and () are matched here.