Re: Field Name

Two ways. The easiest is using the DESCRIBE command.

DESC tablename

That is it.

To get more information issue the following select statement:

SELECT *
FROM user_tab_columns
WHERE table_name = 'your_table_name_here';

Daniel A. Morgan

imail wrote:

> Can you tell me how to list all the fields of a table in a database?
> I've tried the "select * from" statement, however, some of the field
> have data of just one character. Which means the output comes out
> something like:
>
> M
> --
> Y
>
> and I don't get to see what the field name is.
Received on Sat Apr 14 2001 - 00:30:47 CDT