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

7 votes272 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote268 views1 answer
Mysql dump for selected row
SQL
13 votes241 views2 answers
Sqlite rename column
SQL
1 vote245 views1 answer
Mysql show current queries
SQL
3 votes292 views1 answer
Oracle undo tablespace schema
SQL
7 votes259 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote278 views1 answer
Grant privileges of databse to user
SQL
1 vote287 views1 answer
Sql how to replace full stop
SQL
5 votes266 views1 answer
Commentaire table oracle
SQL
24 votes256 views5 answers
Sql server insert into select
SQL