August 2011
Intermediate to advanced
416 pages
10h 14m
English
To delete the created files or folders, run the following commands (delete_resources.sql):
Listing 3-3 Deleting Folders and Files in XML DB Repository Using SQL
delete from RESOURCE_VIEW
where equals_path(res,‘/public/chp03/john_smith.xml’)=1;
ROLLBACK;
exec dbms_xdb.deleteresource(‘/public/chp03/john_smith.xml’);
ROLLBACK;
Note that to continue our examples in the following sections, we roll back the file and folder deletions with the ROLLBACK command.
Read now
Unlock full access