Sometimes it would be easy to have a view which is parameterized. One of the options is to use sys_context. Another option is to makeuse of a pipelined function. Example package CREATE OR REPLACE PACKAGE okps_preop_tst IS TYPE outrec_typ IS Read more…
To change the background color of a region assign a static ID to the region and add CSS-styles in top of the page. To color the background with a certain opacity without effect on foreground text use this code: <style> Read more…
To get a background image in Apex just add the following code to a region in a page or in css-part of a page. Putting it into a region its maybe easier to reference item with name of image and Read more…
A classic report in APex can be refreshed dynamically. A pl/sql region is more difficult, you must do this by using an application proces. Create a plsql region calling a procedure/package with htp.p-commands. IE <div id=HK3>xcvxvxvxvc</div> BEGIN show_data; END; create Read more…
You can upload files of course but restiting the file types can be done by changing the following fields: item : The item of type file browse Settings – file types : .xls, .xlsx, .csv , .txt