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 vote125 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote125 views1 answer
Sql string contains case sensitive
SQL
10 votes125 views4 answers
Drop primary key
SQL
2 votes123 views1 answer
Plsql left() function
SQL
0 vote140 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote123 views1 answer
Sql sort ages
SQL
1 vote132 views3 answers
How to reset id column in sql server
SQL
0 vote125 views1 answer
MySql get primary keys of table
SQL
-1 vote124 views1 answer
Mysql order by on condition
SQL
0 vote121 views2 answers
Search stored procedures
SQL