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 vote337 views1 answer
Sql delete all values in a column
SQL
0 vote337 views1 answer
Mysqlimport
SQL
0 vote351 views1 answer
Sql bild in function
SQL
1 vote329 views2 answers
Procedure pl/sql
SQL
4 votes348 views1 answer
Create table if not exist in sqlite
SQL
1 vote392 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote402 views2 answers
Disallowed function mysql to_date()
SQL
0 vote381 views1 answer
Mysql extract day from date leading zero
SQL
0 vote317 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote400 views1 answer
Consecutive numbers sql
SQL