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: Alternative to DESCRIBE

Re: Alternative to DESCRIBE

From: Thomas Kellerer <NNGNVRDSJEBN_at_spammotel.com>
Date: Wed, 16 Mar 2005 16:36:32 +0100
Message-ID: <39r240F664d9rU1@individual.net>


SELECT *
FROM all_tab_columns
WHERE owner = user
AND table_name = 'the_table';

On 16.03.2005 16:34 Robert Wehofer wrote:

> Is there a possibility to select column names and column types of a table
> without using the command DESCRIBE?
>
> Robert
>
>
Received on Wed Mar 16 2005 - 09:36:32 CST

Original text of this message

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