问搜索表以查找匹配的字符串Oracle

EN

SELECT 'select * from ' || table_name || ' where ' || clause
  FROM (SELECT DISTINCT REPLACE(stragg(column_name)
                                  over(PARTITION BY table_name ORDER BY table_name), ',',
                                  ' = ''__your_string__'' OR ') || ' = __your_string__' clause,
                         table_name
           FROM user_tab_columns
          WHERE table_name IN
                (SELECT table_name
                   FROM all_constraints
                  WHERE constraint_type = 'R'
                    AND r_constraint_name IN (SELECT constraint_name
                                                FROM all_constraints
                                               WHERE constraint_type IN ('P', 'U')
                                                 AND table_name = '__yout_table__')));