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
Popular Posts
January 10, 2017
RCU-6002 error in ODI
December 07, 2017
java.sql.SQLException: Invalid column index
Comments
Post a Comment