in reply to Re: obtain fields in table without query
in thread obtain fields in table without query
You can run a "desc table" query using DBI, although you will get some different results on different databases.
MySQL returns a row of data for each column in the table -- (name, datatype, NULL (YES|NO), key, default, auto-increment).
Oracle sees this as an invalid SQL statement.