Oracle Apex 5.1:关于创建空输入表单(如创建表时的输入表单) [英] Oracle Apex 5.1: About creating an empty input form like the input form when creating table

问题描述

我想使用oracle apex 5.1创建一个表单，如下图所示.但是我不知道如何创建它.谁能指导我实现这一目标?

I want to create a form using oracle apex 5.1 like the image below. But I do not know how to create it. Could anyone direct me achieve this?

推荐答案

您可以在查询中使用 APEX_ITEM.TEXT :

select  empno, 
    APEX_ITEM.TEXT(25,ename) ename,
    job, mgr, hiredate from emp;

您必须在报告的列"部分中单击列( ename )，并将转义特殊字符"设置为否. 如果您使用互动式报表，则可以为每个列添加 HTML表达式，例如:

You have to click on column (ename) in Columns section of your report and set Escape special character to No. If you use Interactive report you can put HTML Expression for every column like:

 <input type="text" value="#JOB#">

要在输入中显示列中的数据，只需将值设置为 #NAME_OF_COLUMN#.
对于空输入，只需在查询中添加列:APEX_ITEM.TEXT(25,'') text_input，或者如果您更喜欢第二种方法，则添加空列并设置HTML表达式.

To show data from column in input just set value to be #NAME_OF_COLUMN#.
For empty input just add column in query:APEX_ITEM.TEXT(25,'') text_input or if you prefer second aproach add empty column and set HTML expression.

select empno, ename,'' as text, job, mgr, hiredate from emp;

这是Oracle Apex文档中的APEX_ITEM.TEXT函数.

select empno, ename,'' as text, job, mgr, hiredate from emp;

Here is APEX_ITEM.TEXT function from Oracle Apex doc.

APEX_ITEM.TEXT(
p_idx         IN    NUMBER,
p_value       IN    VARCHAR2 DEFAULT NULL,
p_size        IN    NUMBER DEFAULT NULL,
p_maxlength   IN    NUMBER DEFAULT NULL,
p_attributes  IN    VARCHAR2 DEFAULT NULL,
p_item_id     IN    VARCHAR2 DEFAULT NULL,
p_item_label  IN    VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;

这篇关于Oracle Apex 5.1:关于创建空输入表单(如创建表时的输入表单)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！