Thursday, 28 January 2016

APEX_ITEM



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 1
In 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

Show values in right side of shuttle

While working with select list and shuttle, when we want to display values into right side of shuttle depending upon selection from select ...