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

1 vote176 views1 answer
Mysql breakline on string
SQL
0 vote168 views1 answer
Get who is hired in specific month in sql
SQL
0 vote183 views1 answer
Helptext in sql
SQL
0 vote169 views1 answer
Sql remove decimal places
SQL
0 vote157 views1 answer
Dasebase_url-postgres for windows
SQL
1 vote221 views1 answer
Hangfire clear all jobs
SQL
1 vote155 views1 answer
Psql show with user is logged in
SQL
2 votes175 views2 answers
Select list is not in group by clause
SQL
2 votes173 views1 answer
Oracle number to percentage
SQL
1 vote173 views1 answer
Duplicating a MySQL table with all the data Command
SQL