script retrieval of column names

[Robb Garrioch]

Does anyone know of a DBI method ~or~ MySQL specific way that would
retrieve the column names of a MySQL database.table dynamically within a
Perl script using DBI? or Oracle if known.

Thanks for any info!

Robb