Databases Reference
In-Depth Information
Figure 10-9.
Editing the topics region
15.
Scroll down to the source of the report, and change the existing SQL to the
following:
select
"BOOKID",
"BOOKTITLE",
"CATEGORY"."DESCRIPTION" "BOOKCATEGORY",
"BOOKISBN",
"BOOKPUBLISHER",
"BOOKEDITION",
"BOOKDESCRIPTION",
"BOOKPRICE",
"AUTHOR",
dbms_lob.getlength("BOOKIMAGE") "BOOKIMAGE"
from "BOOKS" LEFT JOIN "CATEGORY" ON "BOOKS"."BOOKCATEGORY" = "CATEGORY"."CATEGORYID"
16.
You should now have the screen shown in Figure 10-10.
