Jamil Muammar
asked on
Select table to other table
Dear Experts,
I have 2 tables similars except for one column
Table1: with columns: col1, col2 col3.
Table 2: with columns col0, col1, col2, col3.
how do I in PL SQL write a procedure to select all rows in Table1 to insert to Table2 according to Columns names, in col0 insert constant value 5.
Thanks
I have 2 tables similars except for one column
Table1: with columns: col1, col2 col3.
Table 2: with columns col0, col1, col2, col3.
how do I in PL SQL write a procedure to select all rows in Table1 to insert to Table2 according to Columns names, in col0 insert constant value 5.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.