Oracle Apex

 https://youtu.be/_9RJD5tVeHo?si=ASp9L6EgpA02dWza https://www.youtube.com/watch?v=ahlW-Jkumto&list=PL_c9BZzLwBRJXk2hEP-U_OUMJAf_TYEiZ

  create table dept( deptno number ( 2 , 0 ), dname varchar2( 14 ), loc varchar2( 13 ), constraint pk_dept primary key (deptno) ) create table emp( empno number ( 4 , 0 ), ename varchar2( 10 ), job varchar2( 9 ), mgr number ( 4 , 0 ), hiredate date , sal number ( 7 , 2 ), comm number ( 7 , 2 ), deptno number ( 2 , 0 ), constraint pk_emp primary key (empno), constraint fk_deptno foreign key (deptno) references dept (deptno) ) insert into DEPT (DEPTNO, DNAME, LOC) values ( 10 , 'ACCOUNTING' , 'NEW YORK' ); insert into dept values ( 20 , 'RESEARCH' , 'DALLAS' ); insert into dept values ( 30 , 'SALES' , 'CHICAGO' ); insert into dept values ( 40 , 'OPERATIONS' , 'BOSTON' ); insert into emp values ( 7839 , 'KING' , 'PRESIDENT' , null , to_date( '17-1...