Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_XMLGEN.GETXML Confusing WHERE clause condition?

Rodney ChanAug 29 2012 — edited Sep 4 2012
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
This post has been answered by Solomon Yakobson on Aug 29 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2012
Added on Aug 29 2012
12 comments
2,362 views