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 vote129 views1 answer
Login failed for login due to trigger execution
SQL
3 votes125 views2 answers
Search text in all sql server stored procedure
SQL
0 vote134 views2 answers
Null value in column violates not-null constraint
SQL
0 vote170 views1 answer
Get last inserted primary key
SQL
0 vote148 views1 answer
Php insert null mysql
SQL
2 votes132 views1 answer
Postgresql create schema in specific database
SQL
1 vote117 views1 answer
Set mysql mode global query
SQL
0 vote116 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote134 views1 answer
Casterar postgres
SQL
-1 vote133 views1 answer
Module operator in oracle sql
SQL