Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Getting data from one table into another
Hi,
I want to call a select statement which data has to be inserted into another table.
Example:
Table A:
ID, VALUE
Select-Statement:
select id, max(values) from tableB group by id
The rows from the statement shall be inserted into Table A.
I was looking for some "Select into" syntax in the online manual but
just found something with variables...
I'm not familiar with Oracle SQL so I'd appreciate any help.
Thanks,
Jens
-- Der Kluegere gibt nach - Eine traurige Wahrheit: sie begruendet die Weltherrschaft der Dummen. - Marie von Ebner-EschenbachReceived on Wed Jul 05 2006 - 05:03:18 CDT