ORACLE EBS AND BI BY KARTHEEK DACHEPALLI
Friday, April 17, 2020
Order of execution plan
›
Below reference clearly explains the order of execution plan. http://www.dba-oracle.com/t_order_sequence_sql_execution_explain_plans_step...
Viewing the actual explain plan of Query
›
step1: add /*+ gather_plan_statistics */ hint in select statement as shown below. select /*+ gather_plan_statistics */ e.first_name,d.de...
Tuesday, January 8, 2019
Pivot, Unpivot in Oracle SQL
›
Below is a sample table. select * from olympic_medal_winners; Pivot: Convert rows to columns. select * from ( select noc,medal...
Generating Calendar using Connect Prior by
›
Note: Replace $Start_dt, $End_dt with the actual start,end dates SELECT TO_CHAR(TO_DATE('$End_dt','M...
1 comment:
Monday, December 31, 2018
Gather stats of a table sytax
›
begin DBMS_STATS.GATHER_TABLE_STATS('owner', 'table_name', estimate_percent=>50,...
Monday, November 12, 2018
ERROR: "Internal error. The Source Qualifier [] contains an unbound field" while running a workflow in PowerCenter
›
Problem Description While running a workflow in the PowerCenter, the following error message is displayed: Internal error. The Source Q...
Thursday, November 1, 2018
SQL to find Monday and Friday of the week of a given date
›
select next_day (sysdate-7,'FRIDAY') Last_Friday, next_day (sysdate-7, 'MONDAY') Last_Monday from dual;
›
Home
View web version
