1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
--
-- $Id: xp_v_1.sql,v 1.2 2006/08/16 07:58:13 source Exp $
--
-- This file is part of the OpenLink Software Virtuoso Open-Source (VOS)
-- project.
--
-- Copyright (C) 1998-2006 OpenLink Software
--
-- This project is free software; you can redistribute it and/or modify it
-- under the terms of the GNU General Public License as published by the
-- Free Software Foundation; only version 2 of the License, dated June 1991.
--
-- This program is distributed in the hope that it will be useful, but
-- WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
-- General Public License for more details.
--
-- You should have received a copy of the GNU General Public License along
-- with this program; if not, write to the Free Software Foundation, Inc.,
-- 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
--
--
create xml view "cat" as
{
"Demo"."demo"."Categories" c as "category" ("CategoryID", "Description" as "description")
{
"Demo"."demo"."Products" p as "product" ("ProductName")
on (p."CategoryID" = c."CategoryID")
}
}
;
create xml view "product" as
{
"Demo"."demo"."Products" p as "product"
("ProductID", "ProductName" as "product_name", "UnitPrice" as "price", "SupplierID", "CategoryID")
{
"Demo"."demo"."Suppliers" s as "supplier" ("CompanyName")
on (s."SupplierID" = p."SupplierID")
,
"Demo"."demo"."Categories" c as "category" ("Description")
on (c."CategoryID" = p."CategoryID")
}
}
;
|
