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 vote196 views1 answer
Create table in dbms cmds
SQL
0 vote192 views1 answer
Sql counter column
SQL
5 votes203 views1 answer
Oracle asynchronous update
SQL
5 votes184 views2 answers
Sql conn
SQL
4 votes201 views2 answers
Sql offset
SQL
14 votes203 views1 answer
Oracle new column
SQL
12 votes186 views3 answers
Install sqlite driver ubuntu
SQL
0 vote189 views1 answer
Mysql earlier than date
SQL
0 vote201 views1 answer
Sql output select
SQL
0 vote256 views1 answer
Select * where id = 1,2,3
SQL