Re: SQL statement to query all fields from a table

From: Carlos <miotromailcarlos_at_netscape.net>
Date: Wed, 06 Jun 2007 00:50:36 -0700
Message-ID: <1181116236.969114.50150@o5g2000hsb.googlegroups.com>

On 6 jun, 09:40, Uwe Ziegenhagen <newsgro..._at_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. Received on Wed Jun 06 2007 - 02:50:36 CDT

This message: [ Message body ]
Next message: Michel Cadot: "Re: start with parent but don't include parent in results"
Previous message: Uwe Ziegenhagen: "SQL statement to query all fields from a table"
In reply to: Uwe Ziegenhagen: "SQL statement to query all fields from a table"
Next in thread: ACMIC: "Re: SQL statement to query all fields from a table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US