oracle apex charts || oracle apex tutorials for beginners || dynamic actions in oracle apex

Опубликовано: 29 Сентябрь 2024
на канале: Tech Probie
5,412
59

hello, viewers today we will see how to create charts in oracle apex and oracle apex charts || oracle apex tutorials for beginners || dynamic actions in oracle apex
How to create resume | resume Kaise banaye | For Freshers & Experienced Both
   • how to make resume in mobile | resume...  

How to Integrate Duo Two Factor Authentication for Microsoft RDP and Windows Logon
   • How to Install Duo security  for Micr...  

Create New Username and Password For your apex application/Authentication Schemes in oracle apex
   • Create  New Username and Password For...  

PayPal Payment Button for website | PayPal account Kaise banaye | Add Credit and Debit Card Button
   • How to create paypal account  | How t...  

Design Login page in Oracle APEX
   • Design Login page in  Oracle APEX  

************CODE***********

select to_char(DATE_, 'YYYY'), sum(AMOUNT)
from (TABLE NAME)
where :P3_FROM is NULL or :P3_TO is NULL or DATE_ between :P3_FROM and :P3_TO
group by to_char(DATE_, 'YYYY')
order by 1



1) Create a new page

2) Create a new table or you can directly load it with CSV/Excel or you can use the existing table also

3)Then Create a new region and change it to chart and in attribute change it to PIE chart from bar chart

4) Then Follow the tutorial

5) Once we create a simple Chart then we will add some more option into it Like a date search filter

6)Then create 2-page items and 1 button and follow the tutorial.

7)check your chart data

#oracleapexcharts #oracleapex #dynamicactions