Can I use insert all only in different tables?

I'm trying to use insert all.

insert all

insert ANIMAL values('dog', 'a001', 'Y')

insert ANIMAL values('dog', 'a002', 'Y')

select 1 from dual;

No, more than one update cursor can be used on a table.

Is it only available once per table?

database

2022-09-22 21:42

1 Answers

Are you using Oracle DB?

INSERT ALL
  INTO Animal (column1, column2, column_n) VALUES ('dog', 'a001', 'Y')
  INTO Animal (column1, column2, column_n) VALUES ('dog', 'a002', 'Y')
SELECT * FROM dual;

Change the insert to int and try it.

2022-09-22 21:42

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656