|
Code Listing 3: Changing the metadata in the RESOURCE_VIEW
update resource_view
set res = updateXml(res,'/Resource/Owner/text()','&1')
where under_path(res,'/home') = 1
and existsNode(res,'/Resource[DisplayName="&1"]') = 1
/
update resource_view
set res = updateXml(res,'/Resource/Owner/text()','&1')
where under_path(res,'/home/&1') = 1
and existsNode(res,'/Resource[DisplayName="questions"]') = 1
/
update resource_view
set res = updateXml(res,'/Resource/Owner/text()','&1')
where under_path(res,'/home/&1') = 1
and existsNode(res,'/Resource[DisplayName="surveys"]') = 1
/
-- etc...
commit;
|
Bookmark
