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

5 votes240 views1 answer
Migrate sql table another database
SQL
8 votes220 views1 answer
Mac restore mysql database command line
SQL
0 vote179 views1 answer
How to check replication lag in mySQL
SQL
1 vote165 views1 answer
Sql only five first row
SQL
0 vote188 views1 answer
Mysql random number between 1 and 100
SQL
1 vote167 views1 answer
Setval pgsql
SQL
0 vote159 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote200 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote200 views1 answer
Mysqldump: error:
SQL
0 vote208 views2 answers
Sql update multiple tables
SQL