In Oracle, one reveals the column names with

select
   COLUMN_NAME
from
   ALL_TAB_COLUMNS
where
   TABLE_NAME = 'NAME_OF_TABLE'
[download]

TAMTOWTDI, but it seems to me that using SQL for sql-type things and DBI for database connectivity is a more successful strategy.

r,

Augie