Creating Charts with Oracle APEX 19.2
ฝัง
- เผยแพร่เมื่อ 20 ก.ย. 2024
- Simple but useful tutorial video for creating chart with Oracle Apex 19.2
Queries are as follows:
Query1:
------------
select t1.deptno||'-'||t2.dname deptno,round(nvl(sum(sal),0)/1000,4) sal
from emp t1, dept t2
where t2.deptno=t1.deptno
group by t1.deptno||'-'||t2.dname
Query2:
-----------
select t1.deptno||'-'||t2.dname deptno,count(empno) cnt
from emp t1, dept t2
where t2.deptno=t1.deptno
group by t1.deptno||'-'||t2.dname
Query3:
-------------
select t1.deptno||'-'||t2.dname deptno,round((nvl(sum(sal),0)/1000)/count(empno),2) avgsal
from emp t1, dept t2
where t2.deptno=t1.deptno
group by t1.deptno||'-'||t2.dname
Thanks
hi, could your make tutorials on jasper reports and its integration with APEX. Thank you.
Top. Thanks.