Number of columns in Table
To know the number of columns in a table with out using describe statement in Oracle SQL
In this blog, I have discussed how to calculate the number of columns in a table without using the
To exemplify this, we will create a table and select the number of columns from the
user_tab_columns view for the current user.
Table Script :
CREATE TABLE EMP
This data dictionary view describes the columns of the tables,views etc for the current user.
WHERE table_name = 'EMP';
Which results to
In this blog, I have discussed how to count the number of columns in the table for the current user.