Beginning Oracle® Application Express

6.3. Calendar Pages

The sample application you are creating has a time-based aspect to its data. It's certainly not unusual to have a date as a key element in one or more data tables.

When there is a date, there is frequently a user request to use this date in the presentation of data. APEX includes a calendar object, which is ideal for this type of display.

You have already learned most of what you will use in creating this page, including the creation of specific SQL statements to provide the required data to the page and creating links from the data displayed on the page.

Try It Out: Creating a Calendar Your new calendar will be on its own page. Return to the development environment, and click the Create button. Clicking the Create button from an existing page gives you the choice of whether you want to create a new entity for the page, a shared component, or a new page. Change the selection to New Page, and click Next. Select the Calendar option, and click Next to bring up the page shown in Figure 6-29. Figure 6-29. Figure 6-29 At this point in your career as an APEX developer, you probably don't need to use the Easy Calendar option. This option is a tiny bit easier than the SQL Calendar option, but the price you pay for avoiding a few mouse clicks is a decrease in the flexibility of the resulting calendar object. Even if you were unfamiliar with SQL before starting this book, ...