You can use the
APEX_ITEM
package to create form elements dynamically based on a SQL query instead of creating individual items page by page.It's sometime necessary that you need to use Item(apex_item) in page,like you want show something when query runs.
Apex_Item will work same as inbuilt option of creating items with Name,Id,Class.
There are several more apex_item which will be useful.
https://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_item.htm#AEAPI199
You can also check Demo which will demonstrate how you can create such items.
If Link Changes in Future then below will be some of the Apex_items you can search and use.
CHECKBOX2 Function
DATE_POPUP Function
DATE_POPUP2 Function
DISPLAY_AND_SAVE Function
HIDDEN Function
MD5_CHECKSUM Function
MD5_HIDDEN Function
POPUP_FROM_LOV Function
POPUP_FROM_QUERY Function
POPUPKEY_FROM_LOV Function
POPUPKEY_FROM_QUERY Function
RADIOGROUP Function
SELECT_LIST Function
SELECT_LIST_FROM_LOV Function
SELECT_LIST_FROM_LOV_XL Function
SELECT_LIST_FROM_QUERY Function
SELECT_LIST_FROM_QUERY_XL Function
TEXT Function
TEXTAREA Function
TEXT_FROM_LOV Function
TEXT_FROM_LOV_QUERY Function
Example:
SELECT empno, APEX_ITEM.HIDDEN(1,empno)|| APEX_ITEM.TEXT(2,ename) ename, APEX_ITEM.TEXT(3,job) job, mgr, APEX_ITEM.DATE_POPUP(4,rownum,hiredate,'dd-mon-yyyy') hd, FROM emp ORDER BY 1In above Example
--.HIDDEN item will be hidden on page(for storing Id you can use this feature)
-- .TEXT with display a text item
-- .DATE_POPUP date popup will be created
No comments:
Post a Comment