Hi,

I am looking for a way to query all fields from a table.

I can use DESC to describe the table but would prefer to receive a
columnwise listing of the fields.


Uwe

On 6 jun, 09:40, Uwe Ziegenhagen <newsgro...@ziegenhagen.info> wrote:
> Hi,
>
> I am looking for a way to query all fields from a table.
>
> I can use DESC to describe the table but would prefer to receive a
> columnwise listing of the fields.
>
> Uwe

Take a look at USER_TAB_COLUMNS.

HTH

Cheers.

Carlos.

On Jun 6, 1:40 am, Uwe Ziegenhagen <newsgro...@ziegenhagen.info>
wrote:
> Hi,
>
> I am looking for a way to query all fields from a table.
>
> I can use DESC to describe the table but would prefer to receive a
> columnwise listing of the fields.
>
> Uwe



SELECT * FROM TABLE_NAME


this will show you every record in the table.