DBMS_XMLGEN.GETXML Confusing WHERE clause condition?
I cant quite wrap my head around this but I found the following query
select * from user_views
where dbms_xmlgen.getxml('select text from user_views where view_name = ''' || view_name || '''') like '%view_table_name%'
What I am totally confuse about is what is the WHERE condition in this query doing?
When I run the "select text" portion it just returns nothing
Would anyone know why the WHERE clause is needed?
Thanks