Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   

 

  Oracle Database Tips by Donald Burleson

Building Tabular Forms with APEX

A tabular form enables the editing of multiple records of a table or view all at once.  Submitting the form will then perform updates or deletes on all the modified rows in the tabular form.  Editing lookup tables is an excellent use for Tabular Forms.

This exercise will create a tabular form on the CONFERENCE_RSVP table.  The COMPANY column will purposely be left out again so it can be added in a different section.

1.       To create the tabular form, navigate to the Easy HTML DB Book application's home page and click the Create Page button.

2.       Choose the Form option and click Next.

3.       Choose the Tabular Form option and click Next.

4.       On the Table / View Owner page:

         Table / View Owner: EASYHDB.

         Allowed Operations: Allow all, UPDATE, INSERT and DELETE.

         Click Next.

5.       On the Table/View Name page type in CONFERENCE_RSVP or select it using the popup from the  icon.  Then click Next.

6.       On the Displayed Columns page:

         Select all columns except for the ID and COMPANY columns.  The COMPANY column will be added later in another exercise.  In this case, displaying the ID column is not desirable since it is the primary key column.

The ID and COMPANY columns can be deselected by holding down the Control key and clicking on them.

         Click Next.

7.       On the Primary Key page:

         Primary Key: ID

There are only two selections.  The form wizards used Automatic Row processes that only support the use of two column primary keys, so two columns can be chosen here.  Tables that have more that two column primary keys would require custom programming and advanced use of the APEX API.  That explanation is beyond the scope of the book.

         Click Next.

8.       On the Primary Key Source page:

         Choose the Existing trigger option.

         Click Next.

9.       On the Updateable Columns page select all columns and click Next.

To keep a column from being editable in the Tabular Form, it would be de-selected here.

10.    On the Page and Region Attributes page:

         Page: 1081.

         Page Name: Tabular Form - CONFERENCE_RSVP.

         Region Title: Conference Attendees.

         Region Template: Leave the default of Report Region.

         Report Template: Leave the default of template: Standard.

         Click Next.

11.    No tabs and click Next.

12.    On the Button Labels page leave the defaults and click Next.

13.    On the Branching page leave the defaults and click Next.

14.    Finally, click Finish then Run the page.

Figure 8.13 shows the completed page as it is now.  Later, the COMPANY column will be added.


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

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.