dynamically feeling adult buttress names list while an sql query

i'm minute sql (for oracle) like:

insert schema1.tablea name * schema2.tablea;

where schema1.tablea schema2.tablea have same columns. however, seems unsafe, given method columns opening behind name undefined. i should doing is:

insert schema1.tablea (col1, col2, ... coln) 
select (col1, col2, ... coln) schema2.tablea;

i'm doing lots tables controlling scripts, i'd something like:

insert schema1.tablea (foo(schema1.tablea)) 
select (foo(schema1.tablea)) schema2.tablea;

where foo nifty incantation extracts buttress names list packages suitable syntax. thoughts?