OracleSQLメモ

数値桁をDBから特定するSQL　NUMBER(9,2)の9桁以下を特定する。

select * from USER_TAB_COLUMNS
where
1=1
AND DATA_TYPE='NUMBER'
AND DATA_PRECISION<=9
AND DATA_SCALE=2
AND ( COLUMN_NAME not like 'GENWA%' AND COLUMN_NAME not like 'TEGWA%')
ORDER BY
TABLE_NAME,
COLUMN_NAME

select * from USER_TAB_COLUMNS

where

1=1

AND DATA_TYPE='NUMBER'

AND DATA_PRECISION<=9

AND DATA_SCALE=2

AND ( COLUMN_NAME not like 'GENWA%' AND COLUMN_NAME not like 'TEGWA%')

ORDER BY

TABLE_NAME,

COLUMN_NAME

月	火	水	木	金	土	日
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31