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 vote326 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
1 vote255 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote258 views1 answer
Alter table name including schema
SQL
1 vote267 views1 answer
Rermove categories woocommerce sql
SQL
0 vote267 views1 answer
Join creating duplicate columns sqllite
SQL
5 votes258 views3 answers
Mysql update field from one table to another
SQL
12 votes268 views6 answers
Between in sql
SQL
0 vote291 views1 answer
How do I insert a blob in SQL?
SQL
1 vote281 views1 answer
Table valued functions in sql
SQL
4 votes306 views3 answers
Postgres drop all tables
SQL