Create sequence student_sequence start with 10000 increment BY 1 - Establishment time
Create Table Students (ID Number (5) Primary Key, First_Name Varchar2 (20), Last_name Varchar2 (20), Major Varchar2 (30), Current_credits Number (3));
- Corresponding table
INSERT INTO Students (id, first_name, last_name, major, current_credits) Values (student_sequence.nextval, 'jessica', 'niu ",' Medicine ', 0);
INSERT INTO Students (id, first_name, last_name, major, current_credits) Values (student_sequence.nextval, 'jessica', 'niu ",' Medicine ', 0);
Student_sequence.nextVal corresponding call
SELECT *.
1 10000 Jessica Niu Medicine 02 10001 Jessica Niu Medicine 0
