Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL statement to query all fields from a table
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