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

ความคิดเห็น • 3

  • @KhubaibAhmad-w1c
    @KhubaibAhmad-w1c 23 วันที่ผ่านมา

    Thanks

  • @mohammadasifiqbal6051
    @mohammadasifiqbal6051 4 ปีที่แล้ว +1

    hi, could your make tutorials on jasper reports and its integration with APEX. Thank you.

  • @fiao110
    @fiao110 3 ปีที่แล้ว

    Top. Thanks.