Oracle - I want to tune the sql query written on two field change peoplecode please help me to tune the query

GeekInterview.com > Tech FAQs > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 70 of 244

I want to tune the sql query written on two field change peoplecode please help me to tune the query as it is very urgent i am pasting the query is
AMT1 = 0;
AMT2 = 0;
AMT3 = 0;
AMT4 = 0;
If All(DATE_FROM) Then
&FROM = " and asof_dt >= %DateIn(:ml_gul_40a_wrk.date_from)";
End-If;
If All(DATE_TO) Then
&TO = " and asof_dt <= %DateIn(:ml_gul_40a_wrk.date_to)";
End-If;
&WHERECLAUSE = " where cust_id =:ml_gul_40a_wrk.cust_id" | &FROM | &TO;
ScrollFlush(RECORD.ML_GUL_40A_VW);
ScrollSelect(1, RECORD.ML_GUL_40A_VW, RECORD.ML_GUL_40A_VW, &WHERECLAUSE);
SortScroll(1, RECORD.ML_GUL_40A_VW, ML_GUL_40A_VW.ASOF_DT, "D");

and the second query is :-

ScrollFlush(SCROLL.ML_GUL_40A_VW, CurrentRowNumber(), SCROLL.ML_GUL_DRILL_VW);
RowScrollSelect(2, RECORD.ML_GUL_40A_VW, CurrentRowNumber(), RECORD.ML_GUL_DRILL_VW, RECORD.ML_GUL_DRILL_VW);
&RETURN = DoModal(PANEL.ML_GUL_SEC_PANEL, "Details", - 1, - 1, 1, RECORD.ML_GUL_40A_VW, CurrentRowNumber());

Total Answers and Comments: 0

Last Update: September 27, 2006 Asked by: snehal

No answers are posted for this question yet.
Be the first to answer it!

What is Change Data Capture

Change Data Capture refers to the process of capturing changes which are made to a production data source. Change Data Capture is typically performed by reading the source of database management software logs. Some of the features of Change Data Capture are It consolidates units of works En

What is an Ad Hoc Query

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. This is in contrast to any query which

Top 5 Reasons Why You Need a Career Change

For many people, a change in career takes place more than three times in their life. Reasons for this vary. There are those who make the change because the reality is that people make mistakes in choosing their career paths and would therefore like to correct that by aiming for what they really want

Career Change: Tips on How to Look for a New Job

Looking for a new job is a task to do. But if you are changing your career after you have been in the same job for quite some time, then your job search becomes even more difficult. Always remember though that your ultimate goal in working is a good career and not just a good job. So don&rsquo

The Right Time To Make A Career Change

Changing careers is one of the most crucial stages in one’s career life. There are employees who get into the career change phase earlier than other employees. But no matter how an employee enjoys his or her current career, there would come a time that an employee would think of shifting c

Career Change: Expect the Unexpected

A career change is a major decision on the part of any working individual. It means getting out of your comfort zone and in most cases, starting from scratch. However, a number of people undergo career change successfully. This is because they had the confidence and the passion to go for their goa

Step-By-Step Plan For A Career Change

Changing a career at the midpoint of anyone’s life is a vital and critical point in everyone’s working life. Everyone undergoes a career shift phase no matter how successful one is at his current job. Because this decision might affect the rest of one’s life, it is nece

Is Career Change The Answer To Your Success?

Personal careers are always a critical aspect for anyone. A career path is not easy to abide by, considering that there will always be external factors such as that of new occupations and job openings of another field that people would want to consider.  There are varying factors that can

Career Change: The Importance Of Career Counseling

Individual careers will always be a delicate matter where people must carefully plan where they envision themselves or how they see themselves now and after some years from now. Being exposed to other potential lines of work, people who are still at the prime of their time can afford to make a shift

Things To Consider When Making A Career Change

Making a career change is not easy. For one, necessary adjustments in terms of work knowledge and familiarization will surely have to start from scratch. This is one of the notable risks that anyone will surely have to go through considering that careers are usually delicate for people who may reach

Featured Free Offers

Request Your Copy

User Name		Remember Me?
Password

Question Bank

No answers are posted for this question yet.Be the first to answer it!