ADS_4_Sequence_synonyms

ORACLE

CREATE TABLE students (
 student_id NUMBER PRIMARY KEY,
 first_name VARCHAR2(50),
 last_name VARCHAR2(50),
 email VARCHAR2(100)
);
CREATE SEQUENCE student_seq
START WITH 1
INCREMENT BY 1
CACHE 20;
INSERT INTO students (student_id, first_name, last_name, email)
VALUES (student_seq.NEXTVAL, 'Alice', 'Johnson', 'alice.johnson@example.com');
INSERT INTO students (student_id, first_name, last_name, email)
VALUES (student_seq.NEXTVAL, 'Bob', 'Smith', 'bob.smith@example.com');
CREATE SYNONYM stu FOR students;
SELECT * FROM stu;