can we count number of columns in a table

[viron86]

i want to know ..............can i count the number if columns are already exist in a table+oracle

[tripy]

you can use google....
The 4 firsts results are giving you your answer.

http://www.google.com/search?q=oracl...ient=firefox-a

1) Adapted from response by Dragan Pavlovic on Thursday, October 31, 2002

select COUNT(COLUMN_NAME)
from dba_tab_columns
where table_name = 'NAME_OF_THE_TABLE_CAPITALS'
AND OWNER='SCHEMA_NAME_CAPITALS'

2) Adapted from response by Scott Tolbert on Thursday, October 31, 2002

select COUNT(*) from dba_tab_columns
where table_name = YourTableNameHere;