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 vote171 views1 answer
Oracle running queries
SQL
0 vote151 views1 answer
Copy data from one postgres container to another
SQL
0 vote176 views1 answer
Select * where id = 1,2,3
SQL
0 vote138 views1 answer
Sql compound operators
SQL
3 votes145 views1 answer
Oracle transaction commit rollback example
SQL
23 votes153 views1 answer
How remove column in mysql
SQL
10 votes173 views2 answers
Select nextval from sequence oracle
SQL
1 vote145 views1 answer
SQL query to get all table records count from a database
SQL
0 vote179 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote168 views1 answer
Oracle winter time change
SQL