Lifecycle Management - Expert Oracle Application Express - page 395

Listing 9-9. View FM BOOKINGS V
CREATE OR REPLACE FORCE VIEW FM BOOKINGS V
AS
SELECT BOOK.BOOK ID,
BOOK.BOOK RES ID,
BOOK.BOOK LOC ID,
RES.RES TITLE,
REST.REST TITLE,
LOC.LOC CITY,
CON.CON TITLE,
CON.CON ID,
USR.USR LAST NAME,
BOOK.BOOK BOOKED FROM,
BOOK.BOOK BOOKED UNTIL,
BOOK.BOOK UPDATED BY,
BOOK.BOOK UPDATED ON
FROM FM BOOKINGS BOOK
INNER JOIN FM RESOURCES RES
ON (RES.RES ID = BOOK.BOOK RES ID)
INNER JOIN FM LOCATIONS LOC
ON (LOC.LOC ID = BOOK.BOOK LOC ID)
INNER JOIN FM RESOURCE TYPES REST
ON (REST.REST ID = RES.RES REST ID)
INNER JOIN FM COUNTRIES CON
ON (CON.CON ID = LOC.LOC CON ID)
INNER JOIN FM USERS USR
ON (USR.USR ID = BOOK.BOOK USR ID);
When you describe this view in your development environment you will see a definition like Figure
9-12 (unless you look at the code behind the view):
Figure 9-12. View definition (data model 2)