It is generally advised to be as explit as possibly when writing code, so
using select * is not acceptable in a production environment - imagine
someone else adding a column to the source table.
S. Bakker's suggestion to use user_tab_columns has worked for me many times.
Good luck,
Erik Ykema.
"Dan." <dan_at_nospam.edu> wrote in message
news:bgbj69$eok$1_at_news.Stanford.EDU...
> Anyone know of an easy way to copy data from table to table that will
match
> up exact same named columns from the source to the target?
Received on Sun Aug 03 2003 - 04:55:59 CDT
