Database Answers
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Tutorials Search Site Map
Tutorial for Asset Management   
We start with this excellent Tutorial from Oracle's Joel Kallman.


Tutorial Step 1 - Create Conceptual POC Tables
Here we discuss thed REquirements with the end-users ...


Tutorial Step 2 - Create Logical POC Tables We use these table to create the Tables in the Database

Tutorial Step 3 Load Test Data
Load a small volume of Test Data into your three Tables.
This is an activity I find tedious so I only create a small volume of 
test records - not more than a dozen. 

Tutorial Step 4 - Here we follow Joel Kallman's Tutorial on Master/Detail. Creating the Application Begin by creating your first Application as a Proof-of-Concept for the important functions of retrieval and display of Customers and their Assets. Here is where you begin your exploration of master/detail support in Oracle Application Express. 1.In Oracle Application Express, click the App Builder tab. 2.Click the Create icon, and then click the Desktop icon. 3.Enter Data Management for Name, and click Next. 4.Click the x in the Home Page row to remove the default home page. 5.Click the Add Page button. 6.Click the Master Detail icon, select REGIONS for Master Table Name, select COUNTRIES for Detail Table Name, and click Add Page. 7.Click the Create Application button, and then click the Create Application button again. You’ve now created a responsive Oracle Application Express application that meets the Requirements of our Proof-of-Concept.

Tutorial Step 5 - Check the Results
At this point we need to check that the results are what we expect.
Unfortunately, we find that the Customer name (Bobby Caldwell) is not displayed.
We are also disspointed to notice that a message is displayed telling us that
'1 rows selected' instead of '1 row selected'.