Skip to main content

Posts

Showing posts from August, 2014

SQL Query to find number of columns of a table

I have been receiving lots of mails on how to find number of columns of a table without using DESCRIBE command or using a statement. This is very simple, you just have to know another Data Dictionary Table USER_TAB_COLUMNS. SELECT count(*) from USER_TAB_COLUMNS where table_name = 'EMP'; Happy Reading........