Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
 

ss

Oracle Tips by Burleson 

Calendars

Calendars can be built two ways in HTML DB:  the Easy Calendar; and the SQL Calendar.

§         Easy Calendar:  Using the Easy Calendar wizard prompts for the table or view to use, and then asks what column to use as the source for the date, and another column for what to display in the calendar.

§         SQL Calendar: This wizard asks the developer to provide a query in which to populate the calendar.  The query must select at least two columns and one of them must be a date.  To display aggregated data, such as a count of records for a date, this wizard will be used to build the query.

The methods for creating both calendars are similar, so creating the Easy Calendar will not be included in detail.  The following example will create a calendar to display the count of conference attendees who responded via RSVP on a date.  The query is simple.

select rsvp_date, count(*) rsvp_count
from  conference_rsvp
group by rsvp_date

Creating a Calendar

1.       Navigate to the Easy HTML DB Book application and click on the Create Page button.

2.       Choose the Calendar option and click Next.

3.       Choose the SQL Calendar option and click Next.

4.       On the Page Attributes screen:

  • Page: 1135.

  • Page Name: Calendar Sample.

  • Region Name: Count of RSVPs by date.

  • Click Next.

5.       No tabs and click Next.

6.       On the Table / View Owner page, enter the following query and click Next:

select rsvp_date, count(*) rsvp_count
from  conference_rsvp
group by rsvp_date

7.       On the Date / Display Columns page:

  • Date Column: RSVP_DATE.

  • Display Column: RSVP_COUNT.

  • Click Next.

8.       Click Finish.

Run the report.  Pressing the Previous button on the calendar several times will get to the month of September 2005.  That is where the data can be found.


The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm

 

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks