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: ACMIC <AACARMICHAEL_at_THEBLUEZONE.NET>
Date: Wed, 06 Jun 2007 15:00:20 -0700
Message-ID: <1181167220.281756.175840@x35g2000prf.googlegroups.com>


On Jun 6, 1:40 am, 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

SELECT * FROM TABLE_NAME this will show you every record in the table. Received on Wed Jun 06 2007 - 17:00:20 CDT

Original text of this message

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