TEMPLATES - Ontoor Blogs

Mega Menu Oracle APEX

Ashish Sahay Jul 12, 2020 2 min read Ashish Sahay APEX APEX MEGA MENU SQL PLUGINS TEMPLATES

Mega Menu Oracle APEX Mega Menu is collapsible floating panel which displays navigation entries at once. It enables users to reduce number of clicks to navigate. Features of Mega Menu Customizable Icons, Descriptions, and Badges Responsive Accessible and Keyboard Friendly How to create? Mega menu can use the exiting …

Coalesce in oracle

Ashish Sahay May 21, 2020 2 min read Ashish Sahay ORACLE Coalesce PLSQL SQL PLUGINS TEMPLATES

Coalesce in ORACLE COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype DROP TABLE coalesce_func_test; CREATE TABLE coalesce_func_test ( id NUMBER, col1 VARCHAR2 (10), col2 VARCHAR2 (10), col3 VARCHAR2 (10), col4 NUMBER ); Sample Data SET …

Coalesce in oracle

Ashish Sahay May 21, 2020 2 min read Ashish Sahay ORACLE Coalesce PLSQL SQL PLUGINS TEMPLATES

Coalesce in ORACLE COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype DROP TABLE coalesce_func_test; CREATE TABLE coalesce_func_test ( id NUMBER, col1 VARCHAR2 (10), col2 VARCHAR2 (10), col3 VARCHAR2 (10), col4 NUMBER ); Sample Data SET …

Preserve Checkbox state while Paginating in Interactive/Classic Report Oracle APEX

Vikas Pandey Apr 11, 2020 2 min read Vikas Pandey APEX APEX PLSQL SQL PLUGINS TEMPLATES

Preserve Checkbox state while Paginating in Interactive/Classic Report Oracle APEX Someone has asked this question to me that how can we preserve checked checkboxes in session state. This Problem will come when the user will check few checkboxes and go to next set of rows via pagination in the report when user will go …

Auto New Line Generation in Interactive Grid Oracle APEX

Vikas Pandey Mar 31, 2020 1 min read Vikas Pandey APEX APEX PLSQL SQL PLUGINS TEMPLATES

Auto New Line Generation in Interactive Grid Oracle APEX Sometimes user don’t want to go with add row button for a new row generation on those cases I will show you how to generate new line without using add row button. for this, you will have to follow some simple steps: Create Interactive grid using following …

APEX Forms Reloaded Part 3

Ashish Sahay Mar 27, 2020 1 min read Ashish Sahay APEX APEX PLSQL SQL PLUGINS TEMPLATES

Auto validation Forms APEX 19 | Part 3 In our tradisional forms we have to write additional code for preventing invalid rows or putting any validation. APEX 19 forms came up with a concept where you can define the row qualifier in query and that’s it, Form will automatically prevent the any invalid row. Create …

New Login Page Template APEX 19 20

Ashish Sahay Mar 26, 2020 1 min read Ashish Sahay APEX APEX PLSQL SQL TEMPLATES

New Login Page template APEX 19 / 20.1 APEX 19 came with New LOGIN page design. Now screen can be display as splitted. Let’s try. We need to change the template type There are two Page layouts Floating Split Floating is old layout, try with split. Select Split layout, save and run. We can use backgrounds as …

How to Create Sticky Menu Bar

Ashish Sahay Mar 11, 2020 2 min read Ashish Sahay CSS CSS HTML TEMPLATES Sticky

How to create sticky header using CSS? To create sticky menu we need to make sure the div must be at the top of the page and stays there when page gets scroll. How do we do that? Make div Position Fixed Define position from TOP. position:fixed; top:0px; Let’s check the full example below <html> …

How to Select All Records in Interactive Report Without Any Limitation

Anuj Kumar Apr 26, 2020 2 min read Anuj Kumar APEX APEX PLSQL SQL apex.server TEMPLATES

Select All records in Interactive Report without any limitation Oracle APEX How to select all records in Interactive Report without any limitation Oracle APEX This approach can be used in case of when a single pagination has more than 50 records. Create a table which has large no of records i.e. INDIA_PINCODE. Create …

APEX Data Parser - How to Parse XLSX and CSV

Ashish Sahay Apr 18, 2020 4 min read Ashish Sahay APEX APEX_DATA_PASER APEX PLSQL SQL PLUGINS TEMPLATES

APEX Data Parser - How to Parse XLSX and CSV? PARSE Function This is the main parser function. It allows to parse XML, XLSX, CSV or JSON files and returns a generic table of the following structure: Structure of parser return LINE_NUMBER, COL001, COL002, COL003, COL004 … COL300 We have line_number and 300 …

How to refresh Static region data in ORACLE APEX?

Ashish Sahay Apr 11, 2020 3 min read Ashish Sahay APEX APEX PLSQL SQL PLUGINS TEMPLATES

Refresh Static region DATA in Oracle APEX I have been receiving couple of queries about the static region refresh. In this article, I’ll try to get through it. Background: In the Interactive and classic reports data refresh from database is done by AJAX. APEX internally calls the AJAX callback to fetch the data …

Set Row Pagination As Select List In Interactive Grid Oracle APEX

Vikas Pandey Apr 6, 2020 1 min read Vikas Pandey APEX APEX PLSQL SQL PLUGINS TEMPLATES

Set Row Pagination As Select List In Interactive Grid Oracle APEX Set Row Pagination As Select List In Interactive Grid Oracle APEX I have Created an Interactive Grid using the following SQL Query. select ID, NAME, LOCATION, COUNTRY from DEPARTMENTS Interactive Grid Attribute as per screenshot: Pagination:= Type …

Master Detail Report in APEX Interactive Report

Ashish Sahay Mar 28, 2020 1 min read Ashish Sahay APEX APEX PLSQL SQL Interactive Report TEMPLATES

Master Detail Report In APEX | No page load Master Detail Report In APEX for standard pages and Dialog pages. When we are working with Master Detail report pages in Oracle APEX, we need to submit the page to set the value of the row/column in one of the page Item. It works with Standard pages very well. But when you …

How to Use v Server Process in Async Mode?

Ashish Sahay Mar 11, 2020 1 min read Ashish Sahay APEX APEX PLSQL SQL PLUGINS TEMPLATES

How to Use APEX Server Process in Async Mode? apex.server.process namespace works in async mode, meaning whenever you hit the process it never waits to complete. Let’s take below example. AJAX process name : GET_EMP_DATA Description: This process bring data from ORDS REST API. function get_data(p_url, …