Oracle Database Discussions

hi,
is there a handy way to rename all columns from a table by adding a prefix, say 'n_' , in a select statement.
if there are just few columns, i can do it this way
select a.col1 n_col1,
a.col2 n_col2,
a.col3 n_col3
from table1 a

while, if there are hundreds of columns, it will drive me crazy to list all the columns.
can i use select * while aliasing columns?

thanks