oracle INSERT INTO SET - ghdrako/doc_snipets GitHub Wiki

The Oracle Database 23.9 RU introduces the INSERT INTO SET syntax - works just like an UPDATE, and is similar to MySQL INSERT INTO SET.

insert into snaks (name,type,quantity) values('Chips','Salt',10);

insert into snaks set 
name = 'Chips',
type = 'Salt'
quantity = 10;