Question

Determining Oracle XML DB Installed on your Machine

Answer 1

You can determine whether or not Oracle XML DB is already installed. If it is installed, then the following are true:

    User XDB exists. To check: SELECT * FROM ALL_USERS;

    View RESOURCE_VIEW exists. To check: DESCRIBE RESOURCE_VIEW

SQL> SELECT * FROM ALL_USERS where username like 'XDB';

USERNAME                          USER_ID CREATED
------------------------------ ---------- ------------------
XDB                                    45 21-FEB-14


SQL> DESCRIBE RESOURCE_VIEW
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 RES                                                XMLTYPE(XMLSchema "http://xm
                                                    lns.oracle.com/xdb/XDBResour
                                                    ce.xsd" Element "Resource")
 ANY_PATH                                           VARCHAR2(4000)
 RESID                                              RAW(16)