Insert result of select statement to another table in Oracle stored procedure
===

I am preparing a stored procedure in oracle. In this procedure I have a select statement which will result in multiple rows. Now I want to insert these rows to another table.

Please someone tell me it is really urgent.

