Hi all.. i am new to oracle database and try to retrieve all the column names and tables names for a particular number (column value from one table). I am using following two different queries but getting no results and no errors. any help??

query1 :
select table_name, column_name from
(select rownum,table_name, column_name, dbms_xmlgen.getxml
('select 1 from "'||table_name||'" where "'||column_name||'"=&number') x
from user_tab_columns where data_type='NUMBER') where length(x)!=0;

query2:

select table_name,
column_name
from( select table_name,
column_name,
to_number(
extractvalue(
xmltype(
dbms_xmlgen.getxml(
'select count(*) c from ' || table_name ||
' where NUMBER(' || column_name || ') = ''589773'''
)
),
'ROWSET/ROW/C'
)
) cnt
from (select utc.*, rownum
from user_tab_columns utc
where data_type in ('NUMBER') ) )
where cnt >= 0

please let me know if u have any questions

Thanks!