Saturday, June 13, 2015

Oracle How to count the number of columns in a table using

Dear readers
If you would like to count the number of column for specific 
table you should use user_tab_columns 
 
 
select count(*) 
from user_tab_columns
where table_name='MYTABLE' --use upper case

No comments:

Post a Comment