开发技术:调查您的应用程序需求
添加时间: 2008-4-26 1:22:32 作者: Oracle指导 阅读次数:9 来源: http://www.d9soft.com
Oracle Application Express builds a quick survey application.
As a product manager for Oracle Application Express (formerly Oracle HTML DB), I often want to gather feedback on workshops or training sessions I deliver. Using Oracle Application Express to quickly create surveys has proven to be so useful that I figured I'd write about it. Even though this column discusses a survey I'd use for one of my sessions, you could just as easily use 10 questions of your own.
Using Oracle Application Express to create, deploy, and compile results for a survey is a natural fit, because the surveys are often needed quite quickly, distribution and access via the Web offer convenience, and results are stored in an Oracle database for easy analysis.
Step 1: Set Up the Tables
To get started, create (or have your Oracle Application Express administrator create) a new workspace. Once you're logged into your workspace, set up tables for your questions:
1. Click SQL Workshop.
2. Click Utilities.
3. Click Data Import/Export.
4. Click Import.
5. Click Import Text Data.
6. Accept the default New Table option for Import To, and select the Copy and Paste option for Import From.
7. Click Next.
8. Copy and paste the list of questions in Listing 1 into the Data field.
9. Click Next.
10. Name the table survey_questions, and click Next.
11. Accept the default primary key options, and click Import Data.
Code Listing 1: Survey questions
Question
How would you rate the effectiveness of the overall workshop?
How would you rate the effectiveness of the overall labs?
How would you rate the presentation skills of the workshop instructor?
How would you rate the quality of the presentation materials?
How would you rate the relevance of the workshop to your job role?
The overall course materials were easy to follow.
The overall course materials matched the subject matter.
Did this workshop meet your expectations?
Please list any additional comments or suggestions for improvement:
If you rated anything a 2 or below, please provide an explanation:
Next, set up a table to hold your survey responses:
1. Click the SQL Workshop tab.
2. Click SQL Scripts.
3. Click Upload.
4. Click Browse; select the make_survey_responses.sql script, available at oracle.com/technology/oramag/oracle/06-mar/o26browser.zip; and click Upload.
5. Click the make_survey_responses.sql icon.
6. Click Run, and then click Run on the Confirmation screen.
7. Optionally, view the results of the script execution, by clicking on the make_survey_responses.sql icon.
Step 2: Create the Application Shell
With the data in place, you can now assemble the application.
1. Click the Application Builder tab.
2. Click Create.
3. Accept the default Create Application option, and click Next.
4. Enter Workshop Survey as the name, and click Next.
5. Accept the Blank option as the Page Type, enter Oracle Application Express Workshop Survey as the Page Name, and click Add Page.
6. Enter two more blank pages with the Page Name Workshop Survey cont. and Thanks, respectively, and then click Next.
7. Select No Tabs, and click Next.
8. Click Next.
9. Because the survey will be anonymous, select No Authentication for Authentication Scheme, and click Next.
10. Select Theme 10, and click Next.
11. Click Create.
Step 3: Add the Survey Questions into the Application
In the list of pages of your application, click the link for page 1 to go to its definition.
Create a region. From here you will add an HTML region into which you will place your first eight questions:
1. Click Create.
2. Select Region on this Page, and click Next.
3. Select HTML, and click Next.
4. Enter Oracle Application Express Workshop Survey in the Title field.
5. Select Page Template Body (1. Items below region Content) for Display Point, and click Next.
6. Enter the following text in the Region Source field, and click Next:
Please answer the questions below, using a scale of 1 to 5, where 1 is "poor" or "strongly disagree" and 5 is "excellent" or "strongly agree."
7. Click Create Region.
Add questions. Now add the questions into the region.
1. In the Items section of the page 1 definition screen, click the Add icon (the document icon with a "+" sign).
2. Click Create multiple items at the bottom of this screen.
3. In the Create Items in Region list, select the new HTML region—Oracle Application Express Workshop Survey.
4. Enter eight items named P1_Q1 through P1_Q8, and for the Type of each item, select Hidden.
5. Click Create Multiple Items.
Create a list of values. Now add a dynamic list of values to the application.
开发技术:调查您的应用程序需求(1) 第 [1] [2] 下一页
上一篇文章: 开发技术:关于变量、移动以及含义 下一篇文章: 解决方案：Oracl数据库中大数据的备份
相关文章: