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

On Thu, 14 Sep 2000 16:02:42 +0100, David Newcomb wrote: >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 > > I think better is : SELECT COLUMN_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME=<your table name> and OWNER=<your owner name> or best: SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME=<your table name> Because the table ALL_TAB_COLUMNS has an OWNER column which specifies the owner of the table and the suggested query could give more than 1 row because more than 1 OWNER could have created a table whith the same name. 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