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

16 votes332 views3 answers
Delete row psql
SQL
2 votes288 views1 answer
Oracle current date without time
SQL
3 votes312 views1 answer
Sql select all
SQL
4 votes330 views2 answers
Convert utc to est sql
SQL
1 vote318 views1 answer
Search for tables with name postgresql
SQL
0 vote334 views1 answer
Xampp increame mysql speed
SQL
0 vote387 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
3 votes336 views3 answers
Start postgresql ubuntu
SQL
2 votes351 views2 answers
Get all tables using like
SQL
0 vote351 views1 answer
Sql date time query find
SQL