Pl sql auto increment

CREATE OR REPLACE TRIGGER dept_bir 
BEFORE INSERT ON departments 
FOR EACH ROW

BEGIN
  SELECT dept_seq.NEXTVAL
  INTO   :new.id
  FROM   dual;
END;
/

Source: stackoverflow.com

Pl sql auto increment

CREATE TABLE departments (
  ID           NUMBER(10)    NOT NULL,
  DESCRIPTION  VARCHAR2(50)  NOT NULL);

ALTER TABLE departments ADD (
  CONSTRAINT dept_pk PRIMARY KEY (ID));

CREATE SEQUENCE dept_seq START WITH 1;

Source: stackoverflow.com

Similar codes

0 vote215 views1 answer
Oracle winter time change
SQL
5 votes232 views3 answers
Sql limit offset
SQL
0 vote196 views1 answer
Mysql uuid
SQL
0 vote198 views3 answers
Sql drop all tables
SQL
1 vote195 views1 answer
Sql server kill all connections
SQL
1 vote204 views1 answer
Postgresql delete cascade
SQL
1 vote214 views1 answer
How to set up a trigger in sql
SQL
51 votes405 views6 answers
Installing mysql on ubuntu
SQL
0 vote204 views1 answer
Sql server list table sizes
SQL
0 vote182 views1 answer
Sql random decimal
SQL