R: [PHP-DB] Oracle column names
| From: | Roberto Sartor | Date: | Thu, 14 Sep 2000 12:08:18 +0000 |
| Subject: | R: [PHP-DB] Oracle column names | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2876@lists.php.net to get a copy of this message | ||
SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME=<your table name>
Ciao
Roberto
> -----Messaggio originale-----
> Da: Francesco D'Inzeo [mailto:f.dinzeo@wintech.it]
> Inviato: martedì 12 settembre 2000 19.59
> A: php-db
> Oggetto: Re: [PHP-DB] Oracle column names
>
>
> On Tue, 12 Sep 2000 17:00:41 +0100, David Newcomb wrote:
>
> >
> >Hi All,
> >
> >Is there a way in Oracle to get a list of the column names
> in a table,
> >even if the table has no records in it?
> >
> >Regards,
> >David.
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> >For additional commands, e-mail: php-db-help@lists.php.net
> >To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
> >
>
> describe "your_table"
> Regards
>
>
> -------------------------------------------------------------------
> "On a day not different than the one now dawning, Leonardo drew the
> first strokes of the Mona Lisa, Shakespeare wrote the first words
> of Hamlet, and Beethoven began work on his Ninth Symphony."
> And Windows98 Crashed!
> -------------------------------------------------------------------
> Francesco D'Inzeo
> WinTech S.r.l.
> Via Lisbona 7
> 35127 PADOVA (Italy)
> Tel. (+39)-(0)49-8703033
> Fax. (+39)-(0)49-8703045
> e-mail f.dinzeo@wintech.it