Number of columns in Table

In this blog, I have discussed how to calculate the number of columns in a table without using the
describe statement.

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
(
  EMPNO     NUMBER(4),
  ENAME     VARCHAR2(10),
  JOB       VARCHAR2(9),
  MGR       NUMBER(4),
  HIREDATE  DATE,
  SAL       NUMBER(7,2),
  COMM      NUMBER(7,2),
  DEPTNO    NUMBER(2)
)

USER_TAB_COLUMS :
    This data dictionary view describes the columns of the tables,views etc for the current user.

Query :
 
 SELECT COUNT(*)
 FROM USER_TAB_COLUMNS
 WHERE table_name = 'EMP';

Which results to

COUNT(*)

----------

8

Summary :

 In this blog, I have discussed how to count the number of columns in the table for the current user.



 



Ebook Download
View all
Learn
View all