Ontoor blogs

Constraints in Nested table

In my previous blog “Working With Nested Table Oracle ” I explained how to work with nested tables. Here we can also define Constraints to the nested table. According to the…

Ashish Sahay April 11, 2017

APEX

Set item at right of interactive Report search bar Oracle APEX

How to Set item at right of APEX interactive Report search bar? We can set the position of any item at the right of the interactive search bar by using…

Ashish Sahay April 6, 2017

ORACLE

Working With Nested Table Oracle

Nested table is awesome feature of Oracle. You can create table inside a table, Which means one column can be treated as a table. Nested tables are faster than the…

Ashish Sahay April 6, 2017

APEX

Avoid printing interactive report column

Use following expression as column condition and column will not print. Copy CodeCopiedUse a different BrowserNVL (SUBSTR (:request, INSTR (:request, '_', -1) + 1), 'ASHISH') NOT IN ('XLS', 'CSV', 'HTMLD',…

Ashish Sahay March 14, 2017

APEX

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…

Ashish Sahay March 13, 2017

APEX

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…

Ashish Sahay March 13, 2017

APEX ORACLE SQL

Get the time when was the Record was inserted

To show the posted time or when the data is inserted into the table. The idea of showing the date in this format came from the social site post time…

Ashish Sahay December 16, 2016

APEX Deprecated

Cascade Select List in Tabular form [Deprecated]

Hey guys, Once I was suffering in manual tabular forms, there I had a requirement of a cascade Select list. Obviously, this is necessary if the user selects a value…

Ashish Sahay December 13, 2016

APEX

Recover Deleted Page in Application with APEX and Firebug

Hey Guys, As usual project development is going on. there, pages can be deleted by any one by mistake, No one wants it but if it happened do not need…

Ashish Sahay October 21, 2016

APEX

Setting Item Value in Session Using PL/SQL in Oracle APEX

Using APEX_UTIL.SET_SESSION_STATE Oracle APEX provides a built-in package APEX_UTIL that includes a procedure SET_SESSION_STATE for setting the value of items in the session state. Here's the syntax: Copy CodeCopiedUse a…

Ashish Sahay October 21, 2016