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 vote379 views1 answer
How to run mysql on terminal mac
SQL
0 vote363 views1 answer
Difference between min and max date sql
SQL
8 votes348 views3 answers
Oracle auto_increment
SQL
0 vote354 views1 answer
Mysql min value row
SQL
1 vote284 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote387 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote350 views1 answer
Sql select min
SQL
0 vote363 views1 answer
Oracle plsql sleep
SQL
1 vote368 views1 answer
Hackerrank sql test solutions
SQL
1 vote333 views2 answers
Sql multiline comment
SQL