您只需要 getValues() 一次,而不是每次遍历循环时
CREATE TABLE employees
(
EMPLOYEE_ID NUMBER(6) PRIMARY KEY NOT NULL,FIRST_NAME VARCHAR(20),LAST_NAME VARCHAR( 25) NOT NULL,EMAIL VARCHAR(25) NOT NULL,PHONE_NUMBER VARCHAR(20),HIRE_DATE DATE NOT NULL,JOB_ID VARCHAR2(10) NOT NULL,SALARY NUMBER(8,2),COMISSION_PCT NUMBER(2,MANAGER_ID NUMBER(6),DEPARTMENT_ID NUMBER(4)
);
CREATE TABLE job_history
(
EMPLOYEE_ID NUMBER(6) PRIMARY KEY NOT NULL,START_DATE DATE NOT NULL,END_DATE DATE NOT NULL,DEPARTMENT_ID NUMBER(4)
);
--Question 1
INSERT INTO employees (EMPLOYEE_ID,LAST_NAME,EMAIL,HIRE_DATE,JOB_ID,DEPARTMENT_ID)
VALUES(176,'Taylor','jasontaylor@gmail.com','1999-AUG-31,'SA_REP',80);
INSERT INTO employees (EMPLOYEE_ID,DEPARTMENT_ID)
VALUES(200,'Whalen','justinwhalen@gmail.com',DATE '1993-06-18','AD_ASST',200);
SELECT LAST_NAME,DEPARTMENT_ID,END_DATE,EMPLOYEE_ID
FROM employees;
NATURAL JOIN job_history;
本文链接:https://www.f2er.com/1198.html