hi all,
i am newbie in oracle and have an issue to deal with my table
i have 2 table lets say (c1) and (c2),
c1 contain the following columns (product_number,product_name,description)
c2 contain the following columns (product_code,product_id,description)
i need to build anonymous blocks including cursor,that cursor fetch the c2 data to insert them in c1 as the following:
product_code = product_number,
product_id = product_name,
description = description
can any one help please...?
thanks for all,
Best regards.