Enter multiple batch data.

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Tue, 15 Jan 2008 2:29 pm

People have an interesting situation here, I have lots of data that will need to be inserted in sequence into multiple tables. Until there is easy, but instead of giving various inserts I insert all at once, to exemplify in MySQL can do like this:
Code: Select all
insert into teste1(campo, campo2) values(5, 6), (4, 2)
how would this situation in Oracle? Be giving several insert ' s a for each row would not slow?
pyro
Location: Barala - TT

Poston Tue, 15 Jan 2008 2:49 pm

tp, you create a table based on the information of another
like this
Code: Select all
Create table teste as select * from teste2
and if the values that you want to register is already in another table can enter so
Code: Select all
insert into table1
select nome
     , sobrenome
     , telefone
  from table2
those are the ways to facilitate an insert Thurs I know..
more if yours doesn't, I don't know this forr ... more I think Thurs will take a pokinhu Yes ... = D I once did a script qui inseriou almost 150 rows in a table.
and it took a pouco no more Axel choice
gokden
Location: Ribeirão Preto - SP

Lucas de Souza

OCA Developer
Analista de sistemas

Poston Tue, 15 Jan 2008 4:06 pm

Brother, do a little research here on the Forum by: Bulk Collect and Forall .
You can move large amount of records.
Might help too.
qualquer thing, says ai.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Tue, 15 Jan 2008 4:47 pm

I searched for these terms.

What I believe to be a problem is that there will be between 2 different banks so you can't use any more direct method like this:
Code: Select all
insert into tabela select * from tabela2
Vlw.
pyro
Location: Barala - TT

Poston Tue, 15 Jan 2008 4:56 pm

Unless you will be DBLink between banks brother.

Then you could give a select a BD, inserting in a table the other BD.

But, that you could be looking at along with the company's DBA, you will know you explain better.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP



Return to SQL

Who is online

Users browsing this forum: Bing [Bot] and 2 guests