Set auto-increment of primary keys in OraclePL/SQL

Oracle does not set the primary key autoincrement function. You need to whitelist the sequences and triggers to automatically increase the primary key.

Oracle does not have the primary key auto increment function. You need to whitelist the sequences and triggers to automatically increase the primary key.

Oracle does not have the primary key auto increment function. You need to whitelist the sequences and triggers to automatically increase the primary key.

Example:

Create a Table menu:

Create table menu (menuId number (10) not null primary key,
Name varchar2 (40) not null,
Id_parent number (10) not null,
Url varchar2 (300) null );

Create the sequence menu_autoinc_seq:

Create sequence menu_autoinc_seq
Minvalue 1
Max value 99999999
Start with 1
Increment by 1
Nocycle
Nocache
Order;

Create trigger menu_autoinc_tg:

Create or replace trigger menu_autoinc_tg
Before insert on menu for each row
Begin
Select menu_autoinc_seq.nextval into: new. menuId from dual;
End menu_autoinc_tg;

The end statement can be written as end;

When creating a database object in Command window, if multiple rows of statements are used, you can start another line after the end of the statement/

Test:

Insert into menu values ('', 'personal transactions ', 0, 'indi. php ');
Insert into menu values ('', 'public transactions ', 0, 'public. php ');