Posts

Showing posts from May, 2020

Move JSON data to a relational table using JSON_TABLE (Projecting Array Elements Using NESTED)

Image
JSON_TABLE , introduced in 12.2, "enables the creation of an inline relational view of JSON content. The JSON_TABLE operator uses a set of JSON path expressions to map content from a JSON document into columns in the view. Once the contents of the JSON document have been exposed as columns, all of the power of SQL can be brought to bear on the content of JSON document."  Step 1:  Invoking a RESTful Style Web Service. Step 2:  First, we need to get the structure of the JSON response returned by apex_web_service.make_rest_request. I then formatted the JSON as below, Formatted JSON:  (Projecting Array Elements using NESTED) [  {     "state": "Andaman and Nicobar Islands",     "statecode": "AN",     "districtData": [       {         "district": "Nicobars",         "notes": "",         "active": 0,         "confirmed": 0,         &qu

Invoking a RESTful Style Web Service in Oracle APEX

Image
The response can be an XML or text such as a comma separated response or JSON. The following is an example of MAKE_REST_REQUEST being used in an application process that is callable by AJAX. Code: declare   l_clob clob;   l_buffer         varchar2(32767);   l_amount         number;   l_offset         number; begin   l_clob := apex_web_service.make_rest_request(               p_url => ' https://api.covid19india.org/v2/state_district_wise.json ',               p_http_method => 'GET');     l_amount := 32000;     l_offset := 1;     begin         loop             dbms_lob.read( l_clob, l_amount, l_offset, l_buffer );             htp.p(l_buffer);             l_offset := l_offset + l_amount;             l_amount := 32000;         end loop;     exception         when no_data_found then             null;     end; end; That's it. Happy APEXing!!!...

Flip Checkbox in Oracle APEX using HTML, CSS and JS

Image
Here i am giving an example to create flip checkbox using HTML, CSS and JavaScript in Oracle APEX. In this example, we will create a flip checkbox using HTML and CSS and will assign a value 'Y' if the checkbox is checked and 'N' if the checkbox is unchecked to a page item using JS. Follow below steps to achieve this, Step 1:  Create Static Region and do copy and paste below code into source section. HTML and CSS code: <html> <head> <style>    table {    border-collapse: separate;    border-spacing: 0 5px;    }    .cmn-toggle {    position: absolute;    margin-left: -9999px;    visibility: hidden;    }    .cmn-toggle + label {    display: block;    position: relative;    cursor: pointer;    outline: none;    user-select: none;    }    input.cmn-toggle-yes-no + label {    width: 200px;    height: 40px;    }    input.cmn-toggle-yes-no + label:before,    input.cmn-toggle-yes-no + lab

Change an item label dynamically in Oracle APEX 20.1

Image
Step 1:  Create an Items as follows, Source Item: P2_PARTY_TYPE  Type:  Radio Group List of Values: Person - P; Organization - O; Agent - A; Vendor: V Affected Item: P2_PARTY (Don't give label name. Let it be blank) Step 2:  Create dynamic action as follows, Event =  Change Selection Type =  Item(s) Item(s) =  P2_PARTY_TYPE Condition =  (No Condition) True Action =  Execute JavaScript Code Fire On Page Load =  Yes Selection Type =  (Blank) Code =  (please copy and paste below JavaScript code) JavaScript Code: if ($v("P2_PARTY_TYPE")=='P') {     $("label[for=P2_PARTY]").text("First Name") } else if ($v("P2_PARTY_TYPE")=='O') {     $("label[for=P2_PARTY]").text("Organization") } else if ($v("P2_PARTY_TYPE")=='A') {     $("label[for=P2_PARTY]").text("Agent") } else if ($v("P2_PARTY_TYPE"

Menu Popup with Declarative List in Oracle APEX

Image
Today i got a requirement, i have needed to add more buttons to a page. I was thinking that, instead of adding multiple buttons in a page, why can't we give them an action menu (as same as like IR Action Menu). Actually i had this requirement for my client. Here is an example. Step 1:  Create a List as follows, Navigation:  Shared Components => Lists (Under Navigation) => Create Step 2:  Create a List Region as follows, Type:  List Source: <Choose List from shared components> Static ID:  actions List Template:  Menu Popup Step 3:  Create a Button as follows, Button Template:  Text with Icon Hot: Yes CSS Classes:  class js-menuButton Icon:  fa-chevron-down Action:  Defined by Dynamic Action Static ID:  quicklinks Custom Attributes:  data-menu="actions_menu" Step 4:  Add below CSS in page CSS inline section if required. #quicklinks { border-radius : 5px; } The demo is  here That's it. Happy APEXing!!!...