ORACLE number

最新推荐文章于 2023-12-15 18:13:10 发布

CarloPan

最新推荐文章于 2023-12-15 18:13:10 发布

阅读量878

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/CarloPan/article/details/109313376

版权

oracle 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

data_precision -- 整数
data_scale --小数位

1、查询数据类型为number, data_precision 为null， data_scale 为null 的数据

SELECT DISTINCT t1.TABLE_NAME from sys.dba_tab_cols t1 WHERE t1.data_type = 'NUMBER'
AND t1.data_scale IS null AND t1.DATA_PRECISION IS null AND t1.OWNER NOT LIKE '%SYS%'
AND t1.OWNER NOT LIKE '%ORD%' AND t1.OWNER NOT LIKE '%DBS%' -- IN ('SYS','SYSMAN','MDSYS')

"ID" NUMBER, -- data_precision is null
"SECURITY_GROUP_ID" NUMBER NOT NULL ENABLE, -- data_scale is null

2、查询数据类型为number,DATA_PRECISION IS null data_scale = 0 的数据

SELECT t1.OWNER,t1.TABLE_NAME,t1.COLUMN_NAME ,t1.DATA_TYPE ,t1.DATA_LENGTH ,t1.DATA_PRECISION ,t1.DATA_SCALE
from sys.dba_tab_cols t1 WHERE t1.data_type = 'NUMBER'
AND t1.data_scale = 0 AND t1.OWNER <> 'SYS'

"POSITION1" NUMBER(*,0),
   "POSITION2" NUMBER(*,0),
   "POSITION3" NUMBER(*,0),
   "POSITION4" NUMBER(*,0),
   "POSITION5" NUMBER(*,0),
   "ENUM_ORDER1" NUMBER(*,0),
   "ENUM_ORDER2" NUMBER(*,0),
   "ENUM_ORDER3" NUMBER(*,0),
   "ENUM_ORDER4" NUMBER(*,0),
   "ENUM_ORDER5" NUMBER(*,0),