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 vote352 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
4 votes417 views1 answer
How to check last gather stats on table in oracle
SQL
3 votes333 views3 answers
Update join
SQL
0 vote364 views1 answer
Pgadmin check database
SQL
0 vote346 views1 answer
Oracle service name view
SQL
0 vote330 views1 answer
Mysql join same table multiple times group by
SQL
0 vote339 views1 answer
Mysql query to add hours to column in table
SQL
0 vote351 views1 answer
Oracle 11g forget password
SQL
0 vote331 views1 answer
Sql server sleep
SQL
3 votes358 views2 answers
Sql not contains
SQL