当前位置：首页 > 资讯评论

oracle系统表（oracle数据库基本语句）

全部评论(3)

bibila
user_tab_partitions，user_tab_subpartitions.
2021-09-02 12:16:37

asd
请参阅以下方法：从ALL_TABLE中选择*;表选择*来自系统中的DBA_TABLES;系统表选择* from user_tables;当前用户
2021-09-02 12:15:18

asd
oracle系统自带的练习表有哪些，怎样找,CREATE TABLE EMP(EMPNO NUMBER(4),ENAME VARCHAR2(10),JOB VARCHAR2(9),MGR NUMBER(4),HIREDATE DATE,SAL NUMBER(7, 2),COMM NUMBER(7, 2),DEPTNO NUMBER(2));INSERT INTO EMP VALUES(7369, 'SMITH', 'CLERK', 7902,TO_DATE('17-12-1980', 'DD-MM-YYYY'), 800, NULL, 20);INSERT INTO EMP VALUES(7499, 'ALLEN', 'SALESMAN', 7698,TO_DATE('20-02-1981', 'DD-MM-YYYY'), 1600, 300, 30);INSERT INTO EMP VALUES(7521, 'WARD', 'SALESMAN', 7698,TO_DATE('22-02-1981', 'DD-MM-YYYY'), 1250, 500, 30);INSERT INTO EMP VALUES(7566, 'JONES', 'MANAGER', 7839,TO_DATE('2-04-1981', 'DD-MM-YYYY'), 2975, NULL, 20);INSERT INTO EMP VALUES(7654, 'MARTIN', 'SALESMAN', 7698,TO_DATE('28-09-1981', 'DD-MM-YYYY'), 1250, 1400, 30);INSERT INTO EMP VALUES(7698, 'BLAKE', 'MANAGER', 7839,TO_DATE('1-05-1981', 'DD-MM-YYYY'), 2850, NULL, 30);INSERT INTO EMP VALUES(7782, 'CLARK', 'MANAGER', 7839,TO_DATE('9-06-1981', 'DD-MM-YYYY'), 2450, NULL, 10);INSERT INTO EMP VALUES(7788, 'SCOTT', 'ANALYST', 7566,TO_DATE('09-12-1982', 'DD-MM-YYYY'), 3000, NULL, 20);INSERT INTO EMP VALUES(7839, 'KING', 'PRESIDENT', NULL,TO_DATE('17-11-1981', 'DD-MM-YYYY'), 5000, NULL, 10);INSERT INTO EMP VALUES(7844, 'TURNER', 'SALESMAN', 7698,TO_DATE('8-09-1981', 'DD-MM-YYYY'), 1500, 0, 30);INSERT INTO EMP VALUES(7876, 'ADAMS', 'CLERK', 7788,TO_DATE('12-01-1983', 'DD-MM-YYYY'), 1100, NULL, 20);INSERT INTO EMP VALUES(7900, 'JAMES', 'CLERK', 7698,TO_DATE('3-12-1981', 'DD-MM-YYYY'), 950, NULL, 30);INSERT INTO EMP VALUES(7902, 'FORD', 'ANALYST', 7566,TO_DATE('3-12-1981', 'DD-MM-YYYY'), 3000, NULL, 20);INSERT INTO EMP VALUES(7934, 'MILLER', 'CLERK', 7782,TO_DATE('23-01-1982', 'DD-MM-YYYY'), 1300, NULL, 10);CREATE TABLE DEPT(DEPTNO NUMBER(2),DNAME VARCHAR2(14),LOC VARCHAR2(13) );INSERT INTO DEPT 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');CREATE TABLE BONUS(ENAME VARCHAR2(10),JOB VARCHAR2(9),SAL NUMBER,COMM NUMBER);CREATE TABLE SALGRADE(GRADE NUMBER,LOSAL NUMBER,HISAL NUMBER);INSERT INTO SALGRADE VALUES (1, 700, 1200);INSERT INTO SALGRADE VALUES (2, 1201, 1400);INSERT INTO SALGRADE VALUES (3, 1401, 2000);INSERT INTO SALGRADE VALUES (4, 2001, 3000);INSERT INTO SALGRADE VALUES (5, 3001, 9999);CREATE TABLE DUMMY(DUMMY NUMBER);INSERT INTO DUMMY VALUES (0);COMMIT;ALTER TABLE EMP ADD CONSTRAINT PK_EMP PRIMARY KEY(EMPNO);ALTER TABLE DEPT ADD CONSTRAINTS PK_DEPTNO PRIMARY KEY(DEPTNO);ALTER TABLE EMP ADD CONSTRAINTS FK_DEPTNO FOREIGN KEY(DEPTNO) REFERENCES DEPT(DEPTNO);
2021-09-02 12:15:18

商品推荐