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!
My Oracle always free tier compute was stopped and I am getting an error when I try to upgrade to paid account. Kindly assist.
can you give some " sample data " like this:
with t as (Select 'account01' as account_name, '1990' as year, 'Jan' as month from dual Select 'account02' as account_name, '2000' as year, 'Feb' as month from dual ) select ( your query here ) from t;
the seniors can help after checking the actual results of your query will return. Help seniors to help yourself...
SQL> ed Wrote file afiedt.buf 1 with t (account_name,year,month,sal) as ( 2 select 'u1','2022','January',150 from dual union all 3 select 'u1','2022','February',200 from dual union all 4 select 'u1','2022','March',300 from dual 5 ) 6 select 7 t.* 8 ,sum(sal) over (partition by account_name order by to_date(month||year,'MonthYYYY','NLS_DATE_LANGUAGE=AMERICAN')) ssal 9* from t SQL> / AC YEAR MONTH SAL SSAL -- ---- -------- ---------- ---------- u1 2022 January 150 150 u1 2022 February 200 350 u1 2022 March 300 650