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 vote302 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote333 views1 answer
Show all sequences postgres
SQL
10 votes328 views4 answers
SELECT FROM WHERE
SQL
0 vote323 views1 answer
Trigger vérifier stock
SQL
1 vote308 views1 answer
Load mysql dumb
SQL
0 vote316 views1 answer
Sql cmd no truncate
SQL
1 vote285 views1 answer
Create sample data postgresql
SQL
23 votes325 views4 answers
How to show all users in mysql
SQL
0 vote295 views1 answer
Tsql generate rows
SQL
10 votes257 views1 answer
Oracle view dependencies
SQL