Yearly Archives: 2021

Configuration of Bash_profile

Configuration of Bash_profile   TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export ORACLE_SID=clone export ORACLE_HOME=/u01/oracle/clone/12.1.0 export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib SSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL THREADS_FLAG=native; export THREADS_FLAG…

Read More

Minimum length check for a field using JS

Assume that there is a requirement to set a minimum length for a field and we need to convey the error to the user by changing the border color. It…

Read More

Pipelined Function for String to table-2

When we are working with the ‘Multi Select’ field , we will face difficulty to process each separated values. Here you can split a colon-separated string into rows using an…

Read More

Oracle Date Time Function Some Use Cases

To get the first date of the current month: select sysdate “date” from dual /*Current Date */ union all select trunc(sysdate,’MONTH’) from dual /*getting first day of the month*/ Result:…

Read More

How to Change Interactive Grid Rows Editable Based on The Condition

OverView This document talks about how to change editable in the interactive grid based on the condition. We can achieve this using a simple decode method. If the condition is…

Read More

Hide and Show in Oracle Apex Using JavaScript

OverView This document talks about how to hide and show the elements in oracle apex using JavaScript.By the following method, we can hide and show the oracle apex region, button,…

Read More

Enable/Disable IR Download button based on User Role

Overview By default, the IR region allows to either enable the Download button to all users or disable the Download button to all users. Suppose if there is a requirement…

Read More

How to Add JavaScript Alert When Item Value is Changed

OverView This document talks about how to add the JavaScript alert when the item value is changed. We are going to achieve this in oracle apex using the JavaScript API…

Read More

What is an recursive sub-query factoring?

1. Overview This document talks about an example of a recursive subquery factoring clause. 2. Technologies and Tools Used The following technologies have been used to achieve exporting IR data to Word format. Oracle SQL…

Read More

How to split comma/colon separated string using Oracle APEX API

1. Overview This blog talks about an example of splitting any special character string to an apex collection table using apex API. 2. Technologies and Tools Used The following technologies have been used to achieve…

Read More