Re: R: [PHP-DB] Oracle column names

Thanks, That's just what I wanted. Most people gave the 'describe' answer which dose not work with php! Cheeers, David. ----- Original Message ----- From: Roberto Sartor <roberto@mionetto.it> To: 'Francesco D'Inzeo' <f.dinzeo@wintech.it>; php-db <php-db@lists.php.net> Sent: Thursday, September 14, 2000 1:08 PM Subject: [PHP-DB] R: [PHP-DB] Oracle column names 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 -- 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