Re: sqlplus: column count of table

From: Oliver Meister <nospam1_at_creabyte.ch>
Date: 22 Mar 2005 16:01:48 GMT
Message-ID: <3aatrcF4njnkiU1@individual.net>

Thomas Kellerer tat schreiben :

> On 22.03.2005 13:57 Oliver Meister wrote:
>
>

>> I've been trying with
>>          SELECT COUNT (*) FROM all_tab_columns WHERE table_name =
>>          'tablename'; 
>> But this does not return what it should.
>> 
>> Do you have any suggestions?

>
> You should include the owner in your where clause, because there might
> be more then one table with the same name.
>
> Thomas
>
> P.S.: in the future be more specific "does not return what it should"
> is *very* unclear....

Hi Thomas

Yes, my statement is indeed unclear.
Anyway, putting an 'owner' into the where cause led to the correct count.

Thank you.

Regards,
Oliver Received on Tue Mar 22 2005 - 10:01:48 CST