Insert for each record found - PL/SQL

Question

good morning.

I’m new to Pl/sql and I need to insert 110 records (Number 1 to 110) in a table ( table: stick) for each ID of the court table.

Insert would be more or less:

INSERT INTO vara(vara_id,foro_tribunal_id,nome) 
VALUES (VARA_SEQ.nextval,"TODOS OS FOROS TRIBUNAIS DA TABELA FORO_TRIBUNAL",'1 (DE 1 A 110)');

I have approximately 97,000 records in the court table, would give approximately 10,670,000 Inserts.

What would be the best way to go through all the court table records and enter the 110 values for each record found ?

Answer 1

Try to do that.

INSERT INTO VARA (vara_id, foro_tribunal_id,nome)
SELECT id, nome FROM foro_tribunal

The oracle will take the data from select and do the Insert.

If necessary you can do a Where in SELECT.

In this article here there are other examples.