Re: DESC tableName - need an SQL version...

From: Mark Styles <news_at_lambic.co.uk>
Date: Tue, 30 Oct 2001 17:34:44 GMT
Message-ID: <a4pttt8uc4f1l6onialnsnnb13m0489jkg@4ax.com>

On Tue, 30 Oct 2001 11:16:52 -0600, Huntress <kaeli96_at_yahoo.com> wrote:

>I am trying to write a script that lists all field names for my tables.
>The thing is, the script is not SQLPlus, and can't use the DESC command.
>It has to use standard SQL. Can anyone tell me a way to write an SQL
>SELECT statement that will tell me all the field names for a table?

look at tables USER_TAB_COLUMNS, ALL_TAB_COLUMNS Received on Tue Oct 30 2001 - 11:34:44 CST

This message: [ Message body ]
Next message: Bliss: "Re: MIN and MAX function between colums"
Previous message: Huntress: "DESC tableName - need an SQL version..."
In reply to: Huntress: "DESC tableName - need an SQL version..."
Next in thread: Huntress: "Re: DESC tableName - need an SQL version..."
Reply: Huntress: "Re: DESC tableName - need an SQL version..."

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