oracle数据库中 如何查询类型为number(7,2)允许为空 没有为该列赋值的数据

2024-11-09 09:57:35
推荐回答(1个)
回答1:

select owner , table_name , column_name from dba_tab_columns where DATA_TYPE='NUMBER' and nullable='Y' and DATA_DEFAULT is null and DATA_PRECISION=7 and dATA_SCALE=2 ;