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

3 votes220 views1 answer
Oracle list invalid password ORA-01017
SQL
58 votes431 views6 answers
Create new user in postgres
SQL
0 vote222 views1 answer
Mysql function variable
SQL
2 votes226 views1 answer
Update with join sql server
SQL
0 vote234 views1 answer
Get yesterday date ISO in psql
SQL
2 votes222 views1 answer
Oracle index size calculation
SQL
0 vote250 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote212 views1 answer
How to count null values in sql
SQL
0 vote238 views1 answer
Select 1 from orders
SQL
0 vote234 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL