Codeinsane

• ทำการ Create Table

SQL> CREATE TABLE DEPARTMENT (
  DEPARTMENT_ID NUMBER(4) NOT NULL,
  DEPARTMENT_NAME VARCHAR2(20),
  CONSTRAINT dept_pk PRIMARY KEY(DEPARTMENT_ID)
);

• ทำการ Create Sequence

SQL> CREATE SEQUENCE dept_seq START WITH 1;

• ทำการ Create Trigger

SQL> CREATE OR REPLACE TRIGGER dept_trig
  BEFORE INSERT ON DEPARTMENT
  FOR EACH ROW
BEGIN
  SELECT dept_seq.nextval
  INTO :new.DEPARTMENT_ID
  FROM dual;
END;