Sunday, July 13, 2014

How to count the number of columns in a table using SQL?

select count(*) 
from user_tab_columns
where table_name='table name'

No comments:

Post a Comment