Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL statement to query all fields from a table

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

Original text of this message

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