Re: Field Names

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 14 Apr 2001 13:48:20 +0200
Message-ID: <v5egdtk3eqcsmsve1ed02deb92p929qud6@4ax.com>

On Sat, 14 Apr 2001 01:42:07 GMT, mousepoet <mousepoet_at_att.net> 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:
>
>B

Just do a
describe <tablename>
and try reading the Getting Started Manual and the Oracle Concepts manual or buy Oracle 8i the complete reference, before you bore us to death.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Apr 14 2001 - 06:48:20 CDT