Databases Reference
In-Depth Information
"EMAIL_ADDRESS" NVARCHAR2(255),
"PHONENUMBER" NVARCHAR2(255),
"EMPLOYEEHEADCOUNT" NUMBER(9,0),
CONSTRAINT "CUSTOMERS_PK" PRIMARY KEY ("ID") ENABLE
)
2.
Create the following sample data shown in Listing 8-6.
Listing 8-6.
Sample Data for the Customers Table
INSERT INTO CUSTOMERS (ID, NAME, ADDRESS, ZIP_CODE, COUNTRY, EMAIL_ADDRESS, PHONENUMBER,
EMPLOYEEHEADCOUNT) VALUES ('1','Yakuza
Corp','Akihabara,Tokyo','551119','Japan','
yakuzacorp@test.com','+8112345678',30)
INSERT INTO CUSTOMERS (ID, NAME, ADDRESS, ZIP_CODE, COUNTRY, EMAIL_ADDRESS, PHONENUMBER,
EMPLOYEEHEADCOUNT) VALUES ('2','ACME Corp','ACME City, Texas','12345','United
States','
acmecity@test.com','
987654321',10)
INSERT INTO CUSTOMERS (ID, NAME, ADDRESS, ZIP_CODE, COUNTRY, EMAIL_ADDRESS, PHONENUMBER,
EMPLOYEEHEADCOUNT) VALUES ('3','Shin Corp','Bangrak,
Bangkok','123456','Thailand','
shincorp@test.com','1
2468086',15)
3.
Now, create a new application, and create a report page in the application.
4.
In the Report Page Creation wizard, choose to create the Classic Report type.
Use the default settings for all the steps in the wizard, and click the Next
button until you reach the step that lets you specify the SQL statement for the
report.
5.
Just specify SELECT * FROM CUSTOMERS in this area for the time being.
6.
When the report has been created successfully, choose to edit the report.
7.
In the Page Rendering area of the report, you should see the report node under
the Regions
Body node. Right click on the report item (Report 1), and choose
to Create a new page item, as shown in Figure 8-13.
