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

On Thu, Sep 14, 2000 at 04:02:42PM +0100, David Newcomb wrote: > > Thanks, That's just what I wanted. Most people gave the 'describe' answer > which dose not work with php! because it's a "feature" of sqlplus (which does the "right" selects to retrieve the info) tc > > 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 > > > > -- > 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 -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany