Create ZIP File using APEX_ZIP

Data Types The data types used by the APEX_ZIP package. t_files type t_files is table of varchar2(32767) index by binary_integer; declare l_zip_file blob; begin for l_file in ( select file_name, file_content from my_files ) loop apex_zip.add_file ( p_zipped_blob => l_zip_file, p_file_name => l_file.file_name, …

APEX shortcut variables

APEX shortcut variables are best in dynamic use in Javascript code. We can fetch data from database or can use any hard coded text. Under the shared components we have pretty awesome feature of APEX shortcut. We have several source type available to populate the shortcut variables. * PL/SQl Function body * HTML Text * …

Browse blob file on button click

Hey Guys, Some times user does no want to click on browse button, provided by oracle apex by default. By clicking on button browse image is better experience. How we can achieve this, let us see Here we have one browse file browse type item. By default we know if we click on item it gives file browse window. We can use …

Working with Multi Select List

As we know select list is an item type available in Oracle apex in each of the version, for the single selection you don’t need to bother, it is just below We have a select list in page region Here i have disabled Multi Selection . ITEM Settings Allow Multi Selection - NO Report query is just simple as where …

Set item value in Session using PL/SQL

Some times I feel that the value of item is not setting to it’s session state. we can not save the value to session state until unless we use submit the page with the item or submitting the page items as well. Now try to set it without loading the page let say we have an Item as “P1_DEPT”. Create a …

Pass Item to item Values Using Javascript

Pass Item to item Values Using Javascript in Oracle APEX Here you have two page items, and a button eg.- P3_EMAIL P3_EMAILVIEW Show_BTN Problem - Pass value of P3_EMAIL to P3_EMAILVIEW Step 1 - disable item P3_EMAILVIEW using disable property Step 2 - Add dynamic Action for the button Show_BTN Create dynamic Action …

Region Display Selector

You just need to choose a region named as region display selector in the breadcrumb of the apex page it will show all the regions , those are enabled for display in region display selector. And highlight that one which is on display. must select scroll window option in region display selector attributes.