RVL
asked on
copy table
hi, I would like to copy everything from one table to another
eg i_pn into p_pn then m_pn into p_pn
eg i_pn into p_pn then m_pn into p_pn
Christopher Gordon
Do the table schemas match each other in the tables you're trying to do the copy?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
If the table doesn't exist and you want a copy, you can use
select * into p_pn from i_pn
/peter
If the table doesn't exist and you want a copy, you can use
select * into p_pn from i_pn
/peter