Shulou(Shulou.com)06/01 Report--

This article is about what all the table structures that come with the Oracle database are. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. Tb_emp (employee form) 1. Create the table CREATE TABLE "TEST". "TB_EMP" ("EMPNO" NUMBER (4Magin0) PRIMARY KEY NOT NULL, "ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "MGR" NUMBER (4L0), "HIREDATE" DATE, "SAL" NUMBER (7jue 2), "COMM" NUMBER (7jue 2) "DEPTNO" NUMBER (2. 0)) COMMENT ON COLUMN "TEST". "TB_EMP". "EMPNO" IS 'employee number'; COMMENT ON COLUMN "TEST". "TB_EMP". "ENAME" IS 'name'; COMMENT ON COLUMN "TEST". "TB_EMP". "JOB" IS 'position'; COMMENT ON COLUMN "TEST". "TB_EMP". "MGR" IS 'leadership number'; COMMENT ON COLUMN "TEST". "TB_EMP". "HIREDATE" IS 'entry time' COMMENT ON COLUMN "TEST". "TB_EMP". "SAL" IS 'base salary'; COMMENT ON COLUMN "TEST". "TB_EMP". "COMM" IS 'bonus'; COMMENT ON COLUMN "TEST". "TB_EMP". "DEPTNO" IS 'Department number'; COMMENT ON TABLE "TEST". "TB_EMP" IS 'employee list " 2. Import data INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7369stamp 'Smith', 'shop assistant', 7902) timestamp '1980-12-17 0000lv 00.000000parcels 800); INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7499' Allen', 'salesperson', 7698 timestamp '1981-02-20 0000purl 00.000000ppjj1600z300)) INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7521 minus' Ward', 'salesperson', 7698) timestamp '1981-02-22 0000monger 00.000000congener 1250pence 500pint 30); INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (756 TB_EMP' Jones', 'manager', 7839TIMESTAMP '1981-04-02 0000freel00.0000000000075mnul 20) INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (76654 INSERT INTO 'Martin', 'salesclerk', 7698 INSERT INTO Timestamp '1981-09-28 0000Jill 00.000000Jr 1250pr 1400pr 30); INSERT INTO "TB_EMP" (TIMESTAMP' 1981-05-01 0000MAL 00.0000MAL 00.0000MAL 2850ul null 30) INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7782TIMESTAMP '1981-06-09 0000JI 00.000000JZ 2450); INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (778 Jing' Scott', 'analyst', 756 Daniel TIMESTAMP '1987-04-19 0000JL 00.0000MZ 3000Mol null 20) INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7839 recorder 'King', 'President', NULL,TIMESTAMP '1981-11-17 0000JV 00.000000PM 5000 null VALUES 10); INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (784Med' Turner', 'salesperson', 7698LTIMESTAMP '1981-09-08 0000MAG 00.0000MIT 1500FL0M30) INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7876 INSERT INTO 'Adams', 'shop assistant', 7788) Timestamp '1987-05-23 0000 EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO 00.000000); INSERT INTO "TB_EMP" (Null 20) VALUES (7900 James, "shop assistant", 7698 timestamp' 1981-12-03 00MUR 00.0000MAL 950mnull 30) INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7902 EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO 'Ford,' analyst', 7566) timestamp '1981-12-03 0000purl 00.000000purl 00.000000pr 00.000000pr 00.000000pr 20); INSERT INTO "TB_EMP" (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (794 mai' Miller', 'shop assistant', 7782meme TIMESTAMP '1982-01-23 0000purl 00.0000min 1300L nulle 10) 3. Look up the table SELECT * FROM "TEST". "TB_EMP"

2. Tb_dept (department table) 1. Create the table CREATE TABLE "TEST". "TB_DEPT" ("DEPTNO" NUMBER (2jin0) PRIMARY KEY NOT NULL, "DNAME" VARCHAR2 (14), "LOC" VARCHAR2 (13); COMMENT ON COLUMN "TEST". "TB_DEPT". "DEPTNO" IS 'department number'; COMMENT ON COLUMN "TEST". "TB_DEPT". "DNAME" IS 'department name' COMMENT ON COLUMN "TEST". "TB_DEPT". "LOC" IS 'Department location'; COMMENT ON TABLE "TEST". "TB_DEPT" IS 'Department Table'; 2. Import data INSERT INTO "TB_DEPT" (DEPTNO,DNAME,LOC) VALUES (10dint 'Accounting', 'New York'); INSERT INTO "TB_DEPT" (DEPTNO,DNAME,LOC) VALUES (20J 'Research', 'Dallas') INSERT INTO "TB_DEPT" (DEPTNO,DNAME,LOC) VALUES (30 Magi 'Sale', 'Chicago'); INSERT INTO "TB_DEPT" (DEPTNO,DNAME,LOC) VALUES (40 'Operation', 'Boston'); 3. Look up the table SELECT * FROM "TEST". "TB_DEPT"

3. Tb_bonus (bonus form) 1. Form CREATE TABLE TEST. "TB_BONUS" ("ENAME" VARCHAR2 (10), "JOB" VARCHAR2 (9), "SAL" NUMBER, "COMM" NUMBER); COMMENT ON COLUMN "TEST". "TB_BONUS". "ENAME" IS 'name'; COMMENT ON COLUMN "TEST". "TB_BONUS". "JOB" IS 'position'; COMMENT ON COLUMN "TEST". "TB_BONUS". "SAL" IS 'basic salary' COMMENT ON COLUMN "TEST". "TB_BONUS". "COMM" IS 'bonus'; COMMENT ON TABLE "TEST". "TB_BONUS" IS 'bonus table'; 2. Import data

Vbl.

3. Look up the table

4. Tb_salgrade (wage scale) 1. Build the table CREATE TABLE "TEST". "TB_SALGRADE" ("GRADE" NUMBER, "LOSAL" NUMBER, "HISAL" NUMBER); COMMENT ON COLUMN "TEST". "TB_SALGRADE". "GRADE" IS 'wage scale "; COMMENT ON COLUMN" TEST "." TB_SALGRADE "." LOSAL "IS' minimum wage"; COMMENT ON COLUMN "TEST". "TB_SALGRADE". "HISAL" IS 'maximum wage' COMMENT ON TABLE "TEST". "TB_SALGRADE" IS 'salary scale'; 2. Import data INSERT INTO TEST.TB_SALGRADE (GRADE,LOSAL,HISAL) VALUES (1mem700 1,200); INSERT INTO TEST.TB_SALGRADE (GRADE,LOSAL,HISAL) VALUES (2mem120111400); INSERT INTO TEST.TB_SALGRADE (GRADE,LOSAL,HISAL) VALUES (3mem1401 VALUES); INSERT INTO TEST.TB_SALGRADE (GRADE,LOSAL,HISAL) VALUES (4jing2001jing3000); INSERT INTO TEST.TB_SALGRADE (GRADE,LOSAL,HISAL) VALUES (5d3001 9999) 3. Look up table SELECT * FROM TEST.TB_SALGRADE

5. Tb_users (user table) 1. Create table CREATE TABLE "TEST". "TB_USERS" ("ID" VARCHAR2 (10) PRIMARY KEY NOT NULL, "USERNAME" VARCHAR2 (64), "PASSWORD" VARCHAR2 (64), "AGE" NUMBER (3p0), "SEX" VARCHAR2 (1); COMMENT ON COLUMN "TEST". "TB_USERS". "ID" IS 'user unique id' COMMENT ON COLUMN "TEST". "TB_USERS". "USERNAME" IS 'user name'; COMMENT ON COLUMN "TEST". "TB_USERS". "PASSWORD" IS 'password'; COMMENT ON COLUMN "TEST". "TB_USERS". "AGE" IS 'age'; COMMENT ON COLUMN "TEST". "TB_USERS". "SEX" IS 'gender'; COMMENT ON TABLE "TEST". "TB_USERS" IS 'user table " 2. Import data INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES ('1Zongzhong' Smith, '123456) VALUES (ID,USERNAME,PASSWORD,AGE,SEX) VALUES (' 2ZPER 'Allen', '123456') VALUES (INSERT INTO "TB_USERS" (Ward), '123456') VALUES ('3ZPJ' Ward, '123456' pr 28') INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES; INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES ('5pm' Martin', '123456' VALUES); INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES ('6pm' Blake', '123456' 27pr'1') INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES; INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES; INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES, "123456" ID,USERNAME,PASSWORD,AGE,SEX (King, 123456) INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES; INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES; INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES ("123456", "James", "123456", "James", "123456") INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES; INSERT INTO "TB_USERS" (ID,USERNAME,PASSWORD,AGE,SEX) VALUES ('1400 select', '123456 "select" TEST "." TB_USERS ")

6. Tb_saldetail (salary schedule) 1. Build the table CREATE TABLE "UCLM". "TB_SALDETAIL" ("SALNO" NUMBER (4) PRIMARY KEY NOT NULL, "ENAME" VARCHAR2 (10), "SALYEAR" VARCHAR2 (10), "SALMONTH" VARCHAR2 (4), "SAL" NUMBER (7), "COMM" NUMBER (7), "EMPNO" NUMBER (4)) COMMENT ON COLUMN "UCLM". "TB_SALDETAIL". "SALNO" IS 'salary number'; COMMENT ON COLUMN "UCLM". "TB_SALDETAIL". "ENAME" IS 'name'; COMMENT ON COLUMN "UCLM". "TB_SALDETAIL". "SALYEAR" IS 'pay year "; COMMENT ON COLUMN" UCLM "." TB_SALDETAIL "." SALMONTH "IS' pay month"; COMMENT ON COLUMN "UCLM". "TB_SALDETAIL". "SAL" IS 'basic salary' COMMENT ON COLUMN "UCLM". "TB_SALDETAIL". "COMM" IS 'bonus'; COMMENT ON COLUMN "UCLM". "TB_SALDETAIL". "EMPNO" IS 'employee ID'; "COMMENT ON TABLE"UCLM". "TB_SALDETAIL" IS 'payroll details'; 2. Import data INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (1, 'Smith', '2020,' 01 employees, 800,0, 7369) INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (2, 'Smith', '2020,' 02, 801.14, 300, 7369); INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (3, 'Smith,' 203, 804.21, null, 7369) INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (4, 'Smith', '2020,' 04, 806.41, null, 7369); INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (5, 'Smith,' 2020,'05, 800.55, 100, 7369) INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (6, 'Smith', '2020,' 06, 806.14, 200, 7369); INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (7, 'Smith,' 2020,'07, 800.55, null, 7369) INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (8, 'Smith', '2020,' 08, 806.84, null, 7369); INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (9, 'Smith,' 2020,'09, 800.77, null, 7369) INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (10, 'Smith,' 2020,'10, 806.85, null, 7369); INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (11, 'Smith,' 2020,'11, 800.83, 0, 7369) INSERT INTO TEST.TB_SALDETAIL (SALNO, ENAME, SALYEAR, SALMONTH, SAL, COMM, EMPNO) VALUES (12, 'Smith', '2020,' 12, 806.14, 7369)

Thank you for reading! This is the end of this article on "what are all the table structures in the Oracle database?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.