Oracle APEX:本站Demo用到的table cux.cux_DEMO_IG

接下来我打算做一些APEX IG 和IR的入门教程了;用到的一些表和数据会在这里统一放出来

希望大家一起来学习,共同提高APEX水平

1 这个是Emp的表

create table cux.cux_DEMO_IG
(
empno NUMBER ,---工号
ename VARCHAR2(60),---名字
job VARCHAR2(9),---职位
mgr NUMBER,---主管工号
hiredate DATE,---生日
sal NUMBER(7,2), ---薪水
comm NUMBER(7,2),
onleave VARCHAR2(1) ,
notes VARCHAR2(1000),
deptno NUMBER,---部门ID
flex1 VARCHAR2(1000),
flex2 VARCHAR2(1000),
flex3 VARCHAR2(1000),
flex4 VARCHAR2(1000),
rating NUMBER
);

insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (8042,’GBB’,’CLERK’,”,to_date(‘2023-03-15′,’yyyy-mm-dd’),”,”,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (8025,’FFF’,’SALESMAN’,7839,to_date(”,’yyyy-mm-dd’),’233′,”,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7839,’KING’,’PRESIDENT’,”,to_date(‘1981-11-18′,’yyyy-mm-dd’),’5000′,”,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7698,’BLAKE’,’MANAGER’,7698,to_date(‘1981-05-01′,’yyyy-mm-dd’),’2850′,”,’Y’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7782,’CLARK’,’CLERK’,7839,to_date(‘1981-06-09′,’yyyy-mm-dd’),’1111′,”,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7566,’JONES’,’MANAGER’,7839,to_date(‘1981-04-02′,’yyyy-mm-dd’),’2975′,”,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7788,’SCOTT’,’ANALYST’,7566,to_date(‘1982-12-09′,’yyyy-mm-dd’),’3000′,”,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7902,’FORD’,’ANALYST’,7566,to_date(‘1981-12-03′,’yyyy-mm-dd’),’3000′,”,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7369,’SMITH’,’CLERK’,7902,to_date(‘1980-12-17′,’yyyy-mm-dd’),’1900′,”,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7499,’ALLEN’,’SALESMAN’,7698,to_date(‘1981-02-20′,’yyyy-mm-dd’),’1300′,’300′,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (8024,’TTT’,’SALESMAN’,7698,to_date(‘2023-02-08′,’yyyy-mm-dd’),’2222′,’111′,’Y’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7654,’MARTIN’,’SALESMAN’,7698,to_date(‘1981-09-28′,’yyyy-mm-dd’),’1250′,’1400′,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (7844,’TURNER’,’SALESMAN’,7698,to_date(‘1981-09-08′,’yyyy-mm-dd’),’1500′,’0′,’N’);
insert into cux.cux_DEMO_IG(empno,ename,job,mgr,hiredate,sal,comm,onleave ) values (8027,’GGGGGG’,”,”,to_date(‘2023-02-10′,’yyyy-mm-dd’),’111′,”,’N’);

APEX专家普通

打赏 收藏 海报 链接