Просторы интернета
I’ve just found out that we can specify query block for PRECOMPUTE_SUBQUERY: /*+ precompute_subquery(@sel$2) */
So we can use it now with SQL profiles, SPM baselines and patches.

Oracle has some neat ways of handling hierarchical data. A while back I wrote about how Oracle SQL can find the entire tree of data above or below a node in a hierarchy using the CONNECT BY clause.
What if the requirement is to flatten hierarchical data?
For example, [...]

In an earlier post, we saw how Oracle SQL can be used to transpose data from rows to columns. It is a similar, though simpler, exercise to transpose data from rows to a comma-seperated list.
LISTAGG is a in-built function in Oracle that lets you concatenate multiple [...]
It is well known thing and you can even find it on MOS, but I have a little more simple script for it, so I want to show little example.
First of all we need to start script on local database:
SQL> [...]
I have a couple scripts for plans comparing:
1. https://github.com/xtender/xt_scripts/blob/master/diff_plans.sql
2. http://github.com/xtender/xt_scripts/blob/master/plans/diff_plans_active.sql
But they have dependencies on other scripts, so I decided to create a standalone script for more convenient use without the need to download other scripts and to set up the sql*plus [...]
Today I was asked about strange problem: xmltable does not return data, if xquery specified by bind variable and xml data has xmlnamespaces:
SQL> var x_path varchar2(100); SQL> var x_xml varchar2(4000); SQL> col x format a100; SQL> begin 2 :x_path:='/table/tr/td'; 3 [...]import java.sql.PreparedStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
Application Module Code
public void SettingWhoColumns(String CStringDate) {
java.sql.Date ConvStringDate = null;
try {
[...]
import java.sql.PreparedStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Timestamp;
Application Module Code
public void SettingWhoColumns(String CStringDate) {
java.sql.Date ConvStringDate = null;
try {
Connection conn = [...]

Consider a PL/SQL call to a function which returns a user-defined type (UDT) – say, a SQL Type object. This works well as long as the called function resides in the same database as the calling PL/SQL, but if the called function is in a remote database, the PL/SQL call [...]

An Oracle view is typically like a window to the output of a SQL statement, but sometimes, a single SQL isn’t sufficient to get you the result you want. You may need to do some procedural data manipulation before you get the output you want.
Does this mean, you cannot [...]

Range-based definition of values is a common business scenario, as in the case of mortgage pre-payment penalty charges depending on "pre-payment amount" slabs, or incentives for a dealer depending on "business generated" slabs.
A necessary validation is such cases is that the slabs should have no overlaps: each [...]
In the Controller process request method just write the below code to make whole page read only in one go.
import com.oaframework.toolkit.util.WebBeanUtil;
public void processRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processRequest(pageContext, webBean);
{
[...]
In the Controller process request method just write the below code to make whole page read only in one go.
import com.oaframework.toolkit.util.WebBeanUtil;
public void processRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processRequest(pageContext, webBean);
{
// this class loops all the [...]

Hi Friends,
Recently I got a request from one of my friend to check the feasibility for setting value in one specific segment of KFF.
I tried a lot and finally I was able to accomplish this. Here is the code which you all can refer if [...]

Hi Friends,
Recently I got a request from one of my friend to check the feasibility for setting value in one specific segment of KFF.
I tried a lot and finally I was able to accomplish this. Here is the code which you all can refer if you get this similar kind [...]
Use this code to set event (could be FirePartialAction or FireAction) on any field.
public void processRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processRequest(pageContext, webBean);
oracle.cabo.ui.action.FireAction FireActionA = new oracle.cabo.ui.action.FireAction();
FireActionA.setEvent("RevenueEvent"); //Event Name
FireActionA.setUnvalidated(true);
revenuechk.setPrimaryClientAction(FireActionA); //revenuechk is the Id of the field
[...]
Use this code to set event (could be FirePartialAction or FireAction) on any field.
public void processRequest(OAPageContext pageContext, OAWebBean webBean) {
super.processRequest(pageContext, webBean);
oracle.cabo.ui.action.FireAction FireActionA = new oracle.cabo.ui.action.FireAction();
FireActionA.setEvent("RevenueEvent"); //Event Name
FireActionA.setUnvalidated(true);
revenuechk.setPrimaryClientAction(FireActionA); //revenuechk is the Id of the field
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean){
super.processFormRequest(pageContext, webBean);
if("RevenueEvent".equals(pageContext.getParameter(SOURCE_PARAM)))
{
//Event handling here
}
Thanks,
Anil [...]