Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tab(id_Support INT);
CREATE TABLE tab2(id_Support INT);
INSERT INTO tab2(id_support) VALUES (1);
1 rows affected

CREATE TABLE tab3(id_Support INT);
INSERT INTO tab3(id_support) VALUES (1);
1 rows affected

INSERT INTO tab3(id_support) VALUES (1);
1 rows affected

 SELECT owner, table_name, cnt              
    FROM all_tab_columns, XMLTABLE('/ROWSET/ROW' passing 
                 (dbms_xmlgen.getxmltype(REPLACE(REPLACE(
                 'select COUNT(*) AS cnt from <owner>.<table_name>', '<owner>', owner)
                 , '<table_name>', table_name))) COLUMNS cnt INT)
    WHERE column_name LIKE '%ID_SUPPORT%'
      AND cnt > 0;
ORA-19202: Error occurred in XML processing
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_XMLGEN", line 288
ORA-06512: at line 1