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 vote86 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote90 views1 answer
Postgresql create table with boolean column
SQL
7 votes98 views1 answer
Set sequence value oracle
SQL
11 votes96 views3 answers
Sql line numbers
SQL
28 votes87 views4 answers
Mysql delete database
SQL
0 vote88 views1 answer
Insert array into mysql column
SQL
0 vote128 views1 answer
Eliminate zero from integer mysql
SQL
2 votes92 views1 answer
Apex execute batch job
SQL
2 votes94 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
1 vote87 views1 answer
Where to locate set password for mysql
SQL