AIM: Component is used for Create the Requisition against the Blanket Purchase Agreement For different Locations. SCRIPT: CREATE OR REPLACE ...

Sometimes we will observe HR Operating units table will not show any data in database. For this we need to  do the set up in SQL Developer. ...

For any field if you want throw any exception when entered any special characters.  We need to use following pattern to find. Pattern p = ...

Once any environment get refreshed in EBS, a new dbc file will be generated. Some times we will receive 500 internal error. To over come this we ...

In OAF page, if user want to know how many characters entered in message text input field. Below is the code we need to use in process request. ...

Suppose if we want to call any external URL in OAF page. So you can call as like below. urlname = https://www.google.com/ ...

The data in a GTT is written to the temporary tablespace, which is not directly protected by redo, so using a GTT improves performance by ...

What is it? In previous releases the database stored compilation and execution statistics in a shared sql area which is non persistent. Starting ...

During tuning a query, I found one table has stale statistics. While running gather stats for that table, got below error. Let me demonstrate ...

The simplest method is to add a hint to the query to overcome ORA-00001 Added in 11.2, the ignore_row_on_dupkey_index hint silently ignores ...