Calculating number of columns
How do I calculate the number of columns in a table without using the "DESCRIBE tablename"?
For this one, you can use one of the catalog views, ALL_TAB_COLUMNS. Each row in this view represents a column of a table or view to which you have rights. To illustrate, we'll create a dummy table, and then select a count from the ALL_TAB_COLUMNS view.
create table "ATE"."DUMMY_TABLE"
( dummycol1 numeric(10),
where owner = 'ATE'
and table_name = 'DUMMY_TABLE';
Here is the result of the query.
This was first published in November 2003