1.创建测试表:
DROP TABLE students;
CREATE TABLE students (
id NUMBER(5) PRIMARY KEY,
first_name VARCHAR2(20),
last_name VARCHAR2(20),
major VARCHAR2(30),
current_credits NUMBER(3),
grade varchar2(2));
INSERT INTO students (id, first_name, last_name, major, current_credits,grade)
VALUES (student_sequence.NEXTVAL, \'Scott\', \'Smith\', \'Computer Science\', 98,null);
INSERT INTO students (id, first_name, last_name, major, current_credits,grade)
VALUES (student_sequence.NEXTVAL, \'Margaret\', \'Mason\', \'History\', 88,null);
INSERT INTO students (id, first_name, last_name, major, current_credits,grade)
VALUES (student_sequence.NEXTVAL, \'Joanne\', \'Junebug\', \'Computer Science\', 75,null);
INSERT INTO students (id, first_name, last_name, major, current_credits,grade)
VALUES (student_sequence.NEXTVAL, \'Manish\', \'Murgratroid\', \'Economics\', 66,null);
commit;
本文地址:https://www.stayed.cn/item/6966
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我