Question

oracle如何统计表中的字段个数

Answer 1

你是说表里面有多少列么？

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> select count(COLUMN_NAME) from USER_TAB_COLUMNS where TABLE_NAME='EMP';

COUNT(COLUMN_NAME)
------------------
8

类似察竖悉纤迹的视败乎图还有DBA_TAB_COLUMNS 和 ALL_TAB_COLUMNS

Answer 2

"牛角山麦子" 的回答是对的!

Answer 3

select max(colno) from col where tname='your tablename'