Re: 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 > Ok maybe I forgot something. In SQLPLUS do the following without quotes (") and where your_table is the table You want to know the column names and types : SQLPLUS>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