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 vote131 views1 answer
Order by with where clause in mysql
SQL
2 votes177 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote188 views1 answer
Sql ssrs
SQL
0 vote138 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote135 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote135 views1 answer
Closure in sql
SQL
0 vote131 views1 answer
Snap craft
SQL
12 votes123 views3 answers
Install sqlite driver ubuntu
SQL
1 vote151 views1 answer
Mysql find tables with column name
SQL
2 votes137 views6 answers
Mysql change timezone
SQL