Databases Reference
In-Depth Information
Solution
To create a visual map on your page, you must first set up the sales data sample table used in this recipe.
To do so, follow these instructions:
1.
Create the sample sales table by running the SQL shown in Listing 5-7.
Listing 5-7.
Ccreating the Sample SalesData Table
CREATE TABLE "SALESDATA"
(
"SALES" NUMBER(9,2),
"ID" NVARCHAR2(50),
"COUNTRY" NVARCHAR2(255),
CONSTRAINT "SALESDATA_PK" PRIMARY KEY ("ID") ENABLE
)
INSERT INTO SALESDATA(SALES,ID,COUNTRY) VALUES(5000,1,'UNITED KINGDOM')
INSERT INTO SALESDATA(SALES,ID,COUNTRY) VALUES(6000,2,'IRELAND')
INSERT INTO SALESDATA(SALES,ID,COUNTRY) VALUES(6780,3,'FRANCE')
To create a map to display the data from the SalesData table, follow these instructions:
1.
Open an existing application and choose to create a new page. Choose the
Map page type in the first page of the wizard, as shown in Figure 5-21.
