Welcome to the Oracle APEX Foundations course. Today in this lesson on Creating Database Application Components, I will be talking about calendars. Lets get started. In this lesson, you will learn how to create and use calendars within your APEX application. Oracle APEX has an integrated calendaring component. Calendars in APEX are based on a table or a SQL query that you provide. App Builder includes a built in wizard for generating a calendar with monthly, weekly, daily, and list views. Once you specify the table on which the calendar is based, you can create drill down links to information stored in specific columns and enable drag and drop capability. App Builder supports two types of calendars. The standard calendar is based on the full calendar jQuery library and can only be customized through CSS. The legacy calendar is a template-based calendar and may be deprecated in the future release. Both calendar options enable you to create a calendar based on a table or a SQL query you provide.

During the creation process, you are prompted to select a date column and a display column. Oracle recommends converting all legacy calendars to the latest calendar because it offers a better user interface and numerous additional features. On the screen, you see the sample calendar packaged application. The features of the calendar include the previous button which navigates to the previous month, the next button which navigates to the next month. The month displays a monthly view of all orders. List displays a list of all the orders. It also provides the weekly view and the daily view. You can go ahead and explore the sample calendar starter app to learn more about the calendar features. You can create a calendar as a new page in your application or as a region on an existing page. The data source for your calendar can be a local database or an external data source. Now, let us see how to create a calendar as a page in your application using the Create Page wizard. First, navigate to your application home page and click 'Create Page'.

I have created a demo application and I am in the application home page. Click on 'Create Page'. Select Calendar. Under Page Definition, specify a name. For source type, select either a table or a SQL query. In this example we select table, and select a table with a date column. For this demo, I choose DEMO_PROJECTS table. For navigation, specify the type of navigation to include on this page. In this example, we turn off the breadcrumb by navigation and click on 'Next'. For settings, the display column allows you to select the column which holds the text displayed for events on the calendar. In this example, we select the task name. The START_DATE column is where you can select the column which holds the start date for events displayed on this calendar.

Notice that the start date is automatically selected. For END_DATE column, select the column which holds the end date for events displayed on this calendar. If this attribute is specified, then the calendar displays duration-based events. Select END_DATE. Show Time; select whether the time portion of the date is displayed or not. Once selected, click 'Create Page', click 'Save' and 'Run' page to see how the calendar is displayed. To summarize, you learned how to create and use calendars within your APEX application. I hope you learned something useful. Thank you for watching.