Inserting into table from view

[Kurse]

Sorry if this is not the correct place or way to ask a question here but I am totally new.

I'm looking for some help on inserting fields from a view into a table. Any help or general examples would be greatly appreciated.

 

[Marco Kalter]

There are no specific tools for this in PL/SQL Developer.

If you want to insert specific records from a view into a table, you can write an insert statement like this:

insert into my_table
  (col1, col2, col3)
select col_a, col_b, col_c
  from my_view
  where ...