SQL> conn jyang/jyang@athena
Connected.
SQL> 
SQL> DECLARE
  2     retb boolean;
  3  BEGIN
  4     retb := dbms_xdb.createfolder('/public/mydocs');
  5     commit;
  6  END;
  7  /

PL/SQL procedure successfully completed.

SQL> 
SQL> declare
  2    bret boolean;
  3  begin
  4    bret :=
  5  dbms_xdb.createresource('/public/mydocs/emp_scott.xml','<emp_name>scott</emp_nam
  6  e>');
  7    commit;
  8  end;
  9  /

PL/SQL procedure successfully completed.

SQL> 
SQL> declare
  2    bret boolean;
  3  begin
  4    bret :=
  5  dbms_xdb.createresource('/public/mydocs/emp_david.xml','<emp_name>david</emp_nam
  6  e>');
  7    commit;
  8  end;
  9  /

PL/SQL procedure successfully completed.

SQL> select owner, object_type from dba_objects where object_name='PATH_VIEW';

OWNER                          OBJECT_TYPE                                      
------------------------------ ------------------                               
PUBLIC                         SYNONYM                                          
XDB                            VIEW                                             

SQL> select owner, object_type from dba_objects where object_name='RESOURCE_VIEW';

OWNER                          OBJECT_TYPE                                      
------------------------------ ------------------                               
PUBLIC                         SYNONYM                                          
XDB                            VIEW                                             

SQL> desc resource_view
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 RES                                                SYS.XMLTYPE
 ANY_PATH                                           VARCHAR2(4000)

SQL> desc path_view
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PATH                                               VARCHAR2(1024)
 RES                                                SYS.XMLTYPE
 LINK                                               SYS.XMLTYPE

SQL> select count(1) from resource_view where any_path like '%mydocs%';

  COUNT(1)                                                                      
----------                                                                      
         3                                                                      

SQL> select * from resource_view where any_path like '%mydocs%';

RES                                                                             
--------------------------------------------------------------------------------
ANY_PATH                                                                        
--------------------------------------------------------------------------------
<Resource>                                                                      
  <CreationDate>2003-08-17T15:09:39.476000000</CreationDate>                    
  <ModificationDate>2003-08-17T15:09:39.476000000</ModificationDate>            
  <DisplayName>mydocs</DisplayName>                                             
  <Language>en</Language>                                                       
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/plain</ContentType>                                         
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
/public/mydocs                                                                  
                                                                                
<Resource>                                                                      
  <CreationDate>2003-08-17T15:09:39.758000000</CreationDate>                    
  <ModificationDate>2003-08-17T15:09:39.758000000</ModificationDate>            
  <DisplayName>emp_david.xml</DisplayName>                                      
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
/public/mydocs/emp_david.xml                                                    
                                                                                
<Resource>                                                                      
  <CreationDate>2003-08-17T15:09:39.633000000</CreationDate>                    
  <ModificationDate>2003-08-17T15:09:39.633000000</ModificationDate>            
  <DisplayName>emp_scott.xml</DisplayName>                                      
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
/public/mydocs/emp_scott.xml                                                    
                                                                                

SQL> select count(1) from path_view where path like '%mydocs%';

  COUNT(1)                                                                      
----------                                                                      
         3                                                                      

SQL> select * from path_view where path like '%mydocs%';

PATH                                                                            
--------------------------------------------------------------------------------
RES                                                                             
--------------------------------------------------------------------------------
LINK                                                                            
--------------------------------------------------------------------------------
/public/mydocs                                                                  
<Resource>                                                                      
  <CreationDate>2003-08-17T15:09:39.476000000</CreationDate>                    
  <ModificationDate>2003-08-17T15:09:39.476000000</ModificationDate>            
  <DisplayName>mydocs</DisplayName>                                             
  <Language>en</Language>                                                       
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/plain</ContentType>                                         
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
<LINK xmlns="http://xmlns.oracle.com/xdb/XDBStandard">                          
  <ParentName>public</ParentName>                                               
  <ChildName>mydocs</ChildName>                                                 
  <Name>mydocs</Name>                                                           
  <Flags>AAAABA==                                                               
                                                                                
</Flags>                                                                        
  <ParentOid>T7gRyen7RVKUlSEWzkIcmQ==                                           
                                                                                
</ParentOid>                                                                    
  <ChildOid>Wb2PxZ0pQAGUyUPa3gRt8w==                                            
                                                                                
</ChildOid>                                                                     
</LINK>                                                                         
                                                                                
/public/mydocs/emp_david.xml                                                    
<Resource>                                                                      
  <CreationDate>2003-08-17T15:09:39.758000000</CreationDate>                    
  <ModificationDate>2003-08-17T15:09:39.758000000</ModificationDate>            
  <DisplayName>emp_david.xml</DisplayName>                                      
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
<LINK xmlns="http://xmlns.oracle.com/xdb/XDBStandard">                          
  <ParentName>mydocs</ParentName>                                               
  <ChildName>emp_david.xml</ChildName>                                          
  <Name>emp_david.xml</Name>                                                    
  <Flags>AAAAAA==                                                               
                                                                                
</Flags>                                                                        
  <ParentOid>Wb2PxZ0pQAGUyUPa3gRt8w==                                           
                                                                                
</ParentOid>                                                                    
  <ChildOid>TnbokAPeSGaiGK/O4s49rQ==                                            
                                                                                
</ChildOid>                                                                     
</LINK>                                                                         
                                                                                
/public/mydocs/emp_scott.xml                                                    
<Resource>                                                                      
  <CreationDate>2003-08-17T15:09:39.633000000</CreationDate>                    
  <ModificationDate>2003-08-17T15:09:39.633000000</ModificationDate>            
  <DisplayName>emp_scott.xml</DisplayName>                                      
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
<LINK xmlns="http://xmlns.oracle.com/xdb/XDBStandard">                          
  <ParentName>mydocs</ParentName>                                               
  <ChildName>emp_scott.xml</ChildName>                                          
  <Name>emp_scott.xml</Name>                                                    
  <Flags>AAAAAA==                                                               
                                                                                
</Flags>                                                                        
  <ParentOid>Wb2PxZ0pQAGUyUPa3gRt8w==                                           
                                                                                
</ParentOid>                                                                    
  <ChildOid>bwnopSjsQ4S4iwAbdE1saA==                                            
                                                                                
</ChildOid>                                                                     
</LINK>                                                                         
                                                                                

SQL> 
SQL> -- Creates a link to an existing resource.
SQL> -- This procedures is analogous to creating a hard link in UNIX.
SQL> -- New entries created in path_view, not in resource_view, with the link name as the path.
SQL> call dbms_xdb.link('/public/mydocs/emp_scott.xml','/public/mydocs',
  2  'person_scott.xml');

Call completed.

SQL> select count(1) from resource_view where any_path like '%mydocs%';

  COUNT(1)                                                                      
----------                                                                      
         3                                                                      

SQL> select count(1) from path_view where path like '%mydocs%';

  COUNT(1)                                                                      
----------                                                                      
         4                                                                      

SQL> select * from path_view where path like '%person%';

PATH                                                                            
--------------------------------------------------------------------------------
RES                                                                             
--------------------------------------------------------------------------------
LINK                                                                            
--------------------------------------------------------------------------------
/public/mydocs/person_scott.xml                                                 
<Resource>                                                                      
  <CreationDate>2003-08-17T15:09:39.633000000</CreationDate>                    
  <ModificationDate>2003-08-17T15:09:39.633000000</ModificationDate>            
  <DisplayName>emp_scott.xml</DisplayName>                                      
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>2</RefCount>                                                        
</Resource>                                                                     
<LINK xmlns="http://xmlns.oracle.com/xdb/XDBStandard">                          
  <ParentName>mydocs</ParentName>                                               
  <ChildName>emp_scott.xml</ChildName>                                          
  <Name>person_scott.xml</Name>                                                 
  <Flags>AAAAAA==                                                               
                                                                                
</Flags>                                                                        
  <ParentOid>Wb2PxZ0pQAGUyUPa3gRt8w==                                           
                                                                                
</ParentOid>                                                                    
  <ChildOid>bwnopSjsQ4S4iwAbdE1saA==                                            
                                                                                
</ChildOid>                                                                     
</LINK>                                                                         
                                                                                

SQL> call dbms_xdb.link('/public/mydocs/emp_david.xml','/public/mydocs',
  2  'person_david.xml');

Call completed.

SQL> commit;

Commit complete.

SQL> 
SQL> call dbms_xdb.deleteresource('/public/mydocs/emp_scott.xml');

Call completed.

SQL> call dbms_xdb.deleteresource('/public/mydocs/person_scott.xml');

Call completed.

SQL> call dbms_xdb.deleteresource('/public/mydocs/emp_david.xml');

Call completed.

SQL> call dbms_xdb.deleteresource('/public/mydocs/person_david.xml');

Call completed.

SQL> call dbms_xdb.deleteresource('/public/mydocs');

Call completed.

SQL> commit;

Commit complete.

SQL> 
SQL> spool off