Databases Reference
In-Depth Information
Figure 9-10.
Classical naming convention
In the classical approach, all table names are in singular form and the table alias is not used as a
prefix for all columns. The data model is fine —it just lacks some of the advantages of a prefix notation.
Based on this data model you want to create an APEX page displaying all details for a specific
booking. For that purpose, first create a view to join the relevant tables and display all relevant details, as
shown in Listing 9-8
Listing 9-8.
View
ODT BOOKING V
CREATE OR REPLACE FORCE VIEW ODT BOOKING V
AS
SELECT BOOKING.ID,
BOOKING.RESOURCE ID,
BOOKING.LOCATION ID,
RES.RESOURCE NAME,
