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 votes179 views1 answer
Alter table add comment oracle
SQL
0 vote189 views1 answer
Dbms_output sql developer
SQL
3 votes194 views2 answers
Savepoint in sql
SQL
0 vote204 views1 answer
Postgre query date
SQL
1 vote180 views1 answer
Get url of cpanel database hostname
SQL
1 vote193 views1 answer
Get create table query existing table mysql
SQL
1 vote200 views1 answer
SQL Integer devision
SQL
0 vote182 views1 answer
Sql select rows with different values in one column
SQL
1 vote185 views1 answer
Sql upsert
SQL
3 votes228 views4 answers
Postgresql change timezone on timestamp without timezone
SQL