[精]Oracle APEX 5.0 新手教程(二) 表格式表单

Oracle APEX Tutorial, Tabular Form

1-  Introduction 2-  Create a Tabular Form using Wizard 3-  Create Tabular Form manually 4-  Handling Tabular form

4.1-  Add rows 4.2-  Multiple row update 4.3-  Deleting multiple rows immediately 4.4-  Deleting multiple rows - Prompt before deleting

5-  Maybe you are interested

本文地址：http://blog.csdn.net/sunansheng/article/details/50408924

1- Introduction

You are viewing guidelines for programming  Oracle APEX 5.0. This is the 2nd document which next of:

• Oracle APEX Tutorial for Beginners

Included in this document, I will continue to guide you on  Oracle APEX Database Desktop Application, using Tabular Form.

2- Create a Tabular Form using Wizard

Log in to  Oracle APEX with programmer's account.

• http://localhost:8080/apex

Go to  "Database Application".

Next, going to  "Hello Database Desktop Application"  that you created in the previous guidance

In this application, there are a few pages created in the previous tutorial. Click " Create Page" to create another page.

Create a  Tabular Form:

Enter:

• Page: 7
• Page Name: Emp Tabular Form (7)

Your web page has been created, click RUN to test the newly created page.

Page 7 is running:

Here, the question arises as to how to change some input fields into SELECT LIST or POPUP LOV (List of values). For example, you want to choose a Manager (MGR) through POPUP LOV, and select a Job through SELECT LIST.

Return to the design screen of page 7. Set the properties for the JOB column so that it displays as a SELECT LIST.

Identification:

• Type: Select List

List of Values

• Type: Static Value
• Static Value:

?

1 2 3 4 5 6

STATIC : CLERK;CLERK, SALESMAN;SALESMAN, PRESIDENT;PRESIDENT, MANAGER;MANAGER, ANALYST;ANALYST

The syntax used to declare the static values 

?

1