怎么知道一个表的某个字段是浮点数字?

Question

怎么知道一个表的某个字段是浮点数字?
怎么知道一个表的某个字段是整数数字?比如table1.column1

Answer 1

select COLUMN_NAME, DATA_PRECISION, DATA_SCALE  from user_tab_columns 
where table_name = 'TABLE1' and column_name = 'COLUMN1';
COLUMN_NAME :字段名
DATA_PRECISION :总长度
DATA_SCALE :小数长度
例:
DATA_PRECISION :7
DATA_SCALE :2
→NUMBER(7,2)

Answer 2

更简单的方法:
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>