Definition: A dependent value set is similar to an independent value set, except that the available values in the list and the meaning of a… Read More »How to Create a Dependent Parameters using Dependent Value set
It’s one of the very common requirement to remove non-numeric values from a text field and we can achieve this in several ways using some… Read More »SQL Query to remove Non-Numeric characters from a String
Some times we get Error no. 53 when we preview or validate the template, this is because of improper JRE path mentioned in the options… Read More »XMLP: Error No. 53 while Previewing/Validating the report
Normally, when you connect oracle via SQL*Plus you can specify a connect string such sqlplus apps/apps@DEV. If this is specified, oracle uses tnsnames entry which… Read More »Use $TWO_TASK environment variable to connect to Oracle Database from Unix
Some times we get an error message “Unable to create an instance of the Java Virtual Machine” while opening JDeveloper. We can resolve this problem… Read More »Error while opening JDeveloper: Unable to create an instance of the Java Virtual Machine error
Sql Statements are used to retrieve data from the database. We can get same results by writing different sql queries. But use of the best… Read More »SQL Tuning or SQL Optimization
Upon a requirement I have created a request set with multiple programs in it. I was in a need to pull request ID of the… Read More »How to get Concurrent Request ID of a parent program in a child program of a Request Set?
/********************************************************* *PURPOSE: To findout blocking sessions and kill them * *AUTHOR: Shailender Thallam * **********************************************************/ — DECLARE CURSOR c IS SELECT c.owner, c.object_name, c.object_type, b.SID… Read More »PL/SQL script to find and Kill Blocking Sessions/Objects
Microsoft Excel has a tendency to display number format based columns with no prefix of ZEROs. For example, if there is a value ‘007’ excel… Read More »How to Display Leading Zeros in XMLP Report – Excel Output
There are many ways to generate output in XML tags format, dbms_xmlgen is one of the way to generate. Lets consider an example to display… Read More »PL/SQL Script to Generate XML Tags for XMLP Report