Re: name of columns

Hi !

        Well .... than use all_tab_columns instead.

	If TABLE_NAME is not unique (more than one
	owner has a table with the same name) then
	restrict OWNER.

	If you don't know the owner use ALL_SYNONYMS
	Using Public synonsms: OWNER = 'PUBLIC'
	Using privat synonyms: OWNER = 'ALEMU' (it's an example !)
	and you get TABLE_OWNER. Use it with ALL_TAB_COLUMNS.

	Regards

	Dante A. Notari-Locher
	

Abiy Alemu wrote:
>
> But I'm not the owner of the table. I have only the synonyms on the
> tables. If I issue this select statement, I can not have what I want .
>
> Help !
>

 [snip ]
> > This should work:
> >
> > select column_name from user_tab_columns
> > where table_name = '<table_name>';
> >
> > I think the table name must be in uppercase.
> >
> >
  Received on Fri Sep 05 1997 - 00:00:00 CDT