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

4 votes282 views1 answer
Postgresql change default value
SQL
0 vote308 views1 answer
Running percentage of total postgres
SQL
3 votes307 views2 answers
How to open postgresql in windows
SQL
0 vote247 views1 answer
Query for maximum salary
SQL
0 vote326 views1 answer
Select the date 30 days less that the todays date sql request
SQL
8 votes248 views1 answer
Similarities between ddl and dml
SQL
0 vote292 views1 answer
Drop specific row postgresql
SQL
0 vote294 views1 answer
Sql get date from timestamp
SQL
16 votes289 views6 answers
Mysql find and replace
SQL
0 vote294 views1 answer
Sql DATE = GETDATE()
SQL