Oracle PL/SQL: how can I use INSERT INTO but select data from different tables?

Question

Here's what I want to do:

Insert some data being passed into a procedure into a new table, but also include some data from another table too.

Example:

INSERT INTO my_new_table(name, age, whatever) VALUES (names.name, ages.age, passed_in_data);

But that won't work.

I did check another question on here, but it was a bit much for my feeble brain.

René Nyffenegger · Accepted Answer · 2010-04-22 10:07:23Z

3

Something like this should do it:

insert into my_new_table (
  name,
  age,
  whatever
)
select 
  names.name,
  ages.age,
  passed_in_data
from
  names   inner join
  ages on ....
where
  ....

answered Apr 22, 2010 at 10:07

René Nyffenegger

40.9k36 gold badges180 silver badges321 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle PL/SQL: how can I use INSERT INTO but select data from different tables?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related