Oracle PL/SQL sets auto-increment of primary keys

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 ');