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

2 votes203 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote233 views1 answer
Dynamic where clause in sql server stored procedure
SQL
1 vote248 views1 answer
Drop colum oracle 18c
SQL
0 vote209 views1 answer
Reindex mssql table
SQL
0 vote208 views1 answer
Sql server select value large text
SQL
2 votes238 views1 answer
Datefromparts mssql
SQL
0 vote200 views1 answer
Sql select all records from all tables where not empty
SQL
3 votes206 views2 answers
Oracle apex charging debug
SQL
0 vote237 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote221 views1 answer
What is initial catalog in sql connection string
SQL