Skip to main content
Search
Search This Blog
Pratik's Blog
Share
Get link
Facebook
X
Pinterest
Email
Other Apps
November 30, 2016
Finding No. of columns in table
Here is query to find No. of columns in table.
select table_name, count(column_name)as No_of_Column from USER_TAB_COLUMNS group by table_name order by table_name asc;
Comments
Comments
Post a Comment