SQLize | PHPize | SQLtest

PROMPT student_sequence... DROP SEQUENCE student_sequence; CREATE SEQUENCE student_sequence START WITH 10000 INCREMENT BY 1; PROMPT students table... DROP TABLE students CASCADE CONSTRAINTS; CREATE TABLE students ( id NUMBER(5) PRIMARY KEY, first_name VARCHAR2(20), last_name VARCHAR2(20), major VARCHAR2(30), current_credits NUMBER(3) ); INSERT INTO students (id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Scott', 'Smith', 'Computer Science', 11); INSERT INTO students (id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Margaret', 'Mason', 'History', 4); INSERT INTO students (id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Joanne', 'Junebug', 'Computer Science', 8); INSERT INTO students (id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Manish', 'Murgatroid', 'Economics', 8); INSERT INTO students(id, first_name, last_name, major, current_credits) VALUES(student_sequence.NEXTVAL, 'Patrick', 'Poll', 'History', 4); INSERT INTO students(id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Timothy', 'Taller', 'History', 4); INSERT INTO students(id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Barbara', 'Blues', 'Economics', 7); INSERT INTO students(id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'David', 'Dinsmore', 'Music', 4); INSERT INTO students(id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Ester', 'Elegant', 'Nutrition', 8); INSERT INTO students(id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Rose', 'Riznit', 'Music', 7); INSERT INTO STUDENTS(id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Rita', 'Razmataz', 'Nutrition', 8); INSERT INTO students(id, first_name, last_name, major, current_credits) VALUES (student_sequence.NEXTVAL, 'Shay', 'Shariatpanahy', 'Computer Science', 3);