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

1 vote153 views1 answer
Search for replace in mysql
SQL
1 vote145 views1 answer
Create email address from first and last name in sql
SQL
0 vote107 views1 answer
Calculate discount from original price sql
SQL
0 vote159 views2 answers
How to get last inserted id in sql server c#
SQL
1 vote139 views1 answer
Local sql server
SQL
6 votes156 views1 answer
SQL insert all columns
SQL
0 vote168 views1 answer
Sql quary stuf
SQL
1 vote143 views1 answer
Mysql random limit 1
SQL
2 votes139 views1 answer
Ssh mysql port forwarding
SQL
-2 votes156 views1 answer
No module named '_sqlite3
SQL