Re: sqlplus: column count of table

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.... Received on Tue Mar 22 2005 - 07:02:39 CST