OraFAQ Forum: Server Administration » how to count no. of columns in a table??

Home » RDBMS Server » Server Administration » how to count no. of columns in a table??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to count no. of columns in a table?? [message #373170]

Mon, 02 April 2001 07:41

Arjun V
Messages: 14
Registered: March 2001

Junior Member

How to count the number of columns in particular table??

Report message to a moderator

Re: how to count no. of columns in a table?? [message #373172 is a reply to message #373170]

Mon, 02 April 2001 08:02

Bala
Messages: 205
Registered: November 1999

Senior Member

HI

Select count(column_name) from user_tab_columns where table_name = 'MYTABLE';

Report message to a moderator

Re: how to count no. of columns in a table?? [message #373175 is a reply to message #373172]

Mon, 02 April 2001 08:36

adelia
Messages: 45
Registered: April 2001

Member

I executed this

select count(COD_BAIRRO) from ALL_tab_columns where table_name ='BAIRRO';

and the error ocurred :
select count(COD_BAIRRO) from ALL_tab_columns where table_name ='BAIRRO'
*
ERROR at line 1:
ORA-00904: invalid column name

U known what is it ?

Thanks

Ad�lia

Report message to a moderator

Re: how to count no. of columns in a table?? [message #373176 is a reply to message #373172]

Mon, 02 April 2001 09:00

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi

column_name here is column_name not yourcolumn_name.

try
either
select count(column_name) from ALL_tab_columns where table_name ='BAIRRO'

or
select count(*) from ALL_tab_columns where table_name ='BAIRRO'

Report message to a moderator

Re: how to count no. of columns in a table?? [message #373177 is a reply to message #373172]

Mon, 02 April 2001 09:10

adelia
Messages: 45
Registered: April 2001

Member

Thanks Bala

select count(column_name) from ALL_tab_columns where table_name ='BAIRRO'

It�s ok !

Report message to a moderator

Re: how to count no. of columns in a table?? [message #373201 is a reply to message #373172]

Tue, 03 April 2001 23:18

Naresh
Messages: 27
Registered: March 2001

Junior Member

In simple terms it means :

The column name entered is either missing or invalid.

Enter a valid column name. See to it that the
column_name entered is there in the table.

Try desc table_name

Report message to a moderator

Previous Topic:	how to retrive data starts from Aa till Am from a table?
Next Topic:	Partitioning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 06:00:19 CST 2024