I want to write the plsql stored procedure to insert multiple rows in a table.
Table t1, table t2.
Table t1 column names(c1,c2,c3,c4,c5)
table t2 column name (c2,c3,c4)
column names c2, c3, c4 are same in both tables.
now I want to insert the data into t1 by selecting table t2 data for those columns.