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

5 votes108 views2 answers
Copy data from one database to another
SQL
9 votes128 views4 answers
Last mysql
SQL
0 vote116 views1 answer
Create function in microsoft sql server
SQL
0 vote119 views1 answer
Postgresql print sessions using the database
SQL
0 vote138 views1 answer
Postgresql concat string with separator
SQL
0 vote69 views1 answer
Connection error in mysql workbench
SQL
3 votes104 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
17 votes106 views6 answers
Mysql import sql file
SQL
18 votes107 views4 answers
Mysql current date between two dates
SQL
0 vote99 views1 answer
Trim sql oracle
SQL