Querying the number of fields (columns) in a table in Oracle

If there are a lot of fields in a table, and we want to know the number of fields in this table, it would be cumbersome to use one of the following methods.

Oracle can query the number of fields (columns) using the following SQL

Select COUNT (*) from User_tab_columns where Table_name=upper (' Table name ')

or

Select Max (column_id) from User_tab_columns where Table_name=upper (' Table name ')

Itmyhome

Links: http://blog.csdn.net/itmyhome1990/article/details/44020963

Querying the number of fields (columns) in a table in Oracle