Return all Documents in XML DataBase

Question

in relational database we can query all tables like this:

select table_name from all_all_tables ;

or

select tname from tab;

How to return all xml files from Sedna XML database by using XQuery/XPath just as like we query tables in relational database ?

if I can use function where can I find a documentation for built-in XML Functions.

score 1 · Accepted Answer · answered Nov 02 '15 at 12:11

1

According to http://www.sedna.org/progguide/ProgGuidesu8.html#x14-580002.5.6 it sounds as if $documents gives you "all stand-alone documents, collections and in-collection documents".

answered Nov 02 '15 at 12:11

Martin Honnen

thank you for replying, that is what I am looking for, I tried doc('$documents') it returns documents for system documents like $db_security_data and $modules. And also for user documents I built it. my question is can I control this by displaying only user documents ? – Dev X Nov 02 '15 at 13:39
User documents don't start from '$'. So, XPath can be used for filtering: `doc('$documents')/documents/(document | collection)[not(starts-with(@name, '$'))]` – ruvim Nov 03 '15 at 08:25

1 Answers1