How to enable LOV small Button


List Of Values (LOV) is a very helpful object in Oracle Forms 10g.



To show LOV  in Forms there are two ways :

1- By Pressing CTRL + L from keyboard

2-By pressing pre-assigned Button

another  way is to show the small LOV icon in the item . like this :







This trick can done by editing the file Registry.DAT

it is locatedin the path



C:\DevSuiteHome_1\forms\java\oracle\forms\registry\Registry.dat.



just edit the line app.ui.lovButtons=false

and change it to

app.ui.lovButtons=true



This is a simple  and clean way 

Remove unused Layouts in Oracle Apex

 Tables used : APEX_XXXXXXX.WWV_FLOW_REPORT_LAYOUTS APEX_XXXXXXX.WWV_FLOW_SHARED_QUERIES use the following query to delete unused Layouts. ...