Nishant Goyal

• Aug 14th, 2006

 

Hello ,

  use this commend.

select count(*) from user_tab_columns where table_name= <table name>

Jagan

• Sep 10th, 2006

 

select count(*) from emp

Srinu

• Oct 9th, 2006

 

select table_name,count(*) from user_tab_columns where table_name='????'
group by table_name

Srinu

prasanna

• Nov 14th, 2006

 

hi

    if u dont mind understand the question properly please

Himu

 Profile Answers by Himu Questions by Himu

• Jul 23rd, 2007

 

To see the number of fields on a table use
desc tablename

you will see the number of fields

rajakumar_na

 Profile Answers by rajakumar_na 

• Nov 21st, 2007

 

Hi all plz understand the question.........
Hi Ramki try this!

SELECT COUNT (COLUMN_NAME) FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'TABLENAME';

FOR example;

SQL> SELECT COUNT(COLUMN_NAME) FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'TEST';

COUNT(COLUMN_NAME)
------------------
                 3

SQL> DESC TEST;
 Name                            Null?    Type
 ------------------------------- -------- ----
 ENAME                                    VARCHAR2(20)
 ID                                       VARCHAR2(20)
 SALARY                                   NUMBER

deepakonroll

 Profile Answers by deepakonroll 

• Dec 7th, 2007

 

DECLARE
CURSOR CUR_TABLES IS
SELECT table_name from user_tables;

V_TABLE NUMBER(5);
v_table_name varchar2(100);
BEGIN

FOR I IN CUR_TABLES
LOOP
SELECT COUNT(1)
INTO V_TABLE
FROM (SELECT table_name from user_tables
where table_name=i.table_name);

IF V_TABLE <= 0 THEN
DBMS_OUTput.PUT_LINE('TABLE NAME' || I.TABLE_NAME);
END IF;
END LOOP;
END;

cheers..!!!!