SQL> SET VERIFY OFF
SQL> <font color=blue>SELECT COUNT(*)</font>
  2  <font color=blue>FROM   sys.user_tab_columns   utc</font>
  3  <font color=blue>WHERE  UPPER(utc.table_name) = '&1'</font>
  4  /
Enter value for 1: EMP
  
  COUNT(*)
----------
         8
  
SQL> /
Enter value for 1: DEPT
  
  COUNT(*)
----------
         3
  
SQL> DESC emp
 Name                            Null?    Type
 ------------------------------- -------- ----
 EMPNO                           NOT NULL NUMBER(4)
 ENAME                                    VARCHAR2(10)
 JOB                                      VARCHAR2(9)
 MGR                                      NUMBER(4)
 HIREDATE                                 DATE
 SAL                                      NUMBER(7,2)
 COMM                                     NUMBER(7,2)
 DEPTNO                                   NUMBER(2)
  
SQL> DESC dept
 Name                            Null?    Type
 ------------------------------- -------- ----
 DEPTNO                          NOT NULL NUMBER(2)
 DNAME                                    VARCHAR2(14)
 LOC                                      VARCHAR2(13)
  
SQL>