For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
hi select br,acno,postdate, sum(amt) over (partition by br,acno order by postdate) samt from vcr above query takes too long to parse .. am I doing any wrong here ? please help
Why do you think that? How about providing a reproducible sample test CASE with a create table statement, sample data, number of rows in the table, time taken to run the query If you think it's a parsing problem provide a SESSION trace, explain plan or tkprof output and show us where the parsing issue may exist.
Your question is similar to saying my car is broken and not saying whether the issue is with the engine, brakes... be more specific so people can help
hi was using wrong aliases issue resolved