Re: List of field of a given table

From: Dale Edgar <Dale_at_DataBee.com>
Date: Fri, 18 Oct 2002 15:01:42 +0000 (UTC)
Message-ID: <3db021b8.121875697@news.btclick.com>

Hi Diego

On Fri, 18 Oct 2002 13:43:20 GMT, "Diego Balgera" <diego.balgera_at_nokia.com> wrote:

>A question from a very unexperienced user ...
>Could you please tell me how to list with sql the list of the fields, given
>a table name, in Oracle 7.x?
>Thank you in advance.

At the SQL prompt you can just use the DESCRIBE command. For example if the tables name is EMP you could type: DESCRIBE EMP

Regards
Dale

---

DataBee: Create referentially correct small versions of large Oracle databases for development and test. http://www.DataBee.com Received on Fri Oct 18 2002 - 10:01:42 CDT