Oracle Database で使われているデータ型を調べる SQL

set pagesize 10000
set linesize 200
col data_type for a30

select data_type, owner, count(1) from dba_tab_columns
	group by data_type, owner
	order by data_type, owner;

実行結果

DATA_TYPE                      OWNER                            COUNT(1)
------------------------------ ------------------------------ ----------
ALERT_TYPE                     SYS                                     3
ANYDATA                        SYS                                    45
ANYDATA                        WMSYS                                   2
AQ$_AGENT                      SYS                                     1
AQ$_EVENT_MESSAGE              SYS                                     3
AQ$_SIG_PROP                   SYS                                    12
AQ$_SIG_PROP                   WMSYS                                   2
AQ$_SRVNTFN_MESSAGE            SYS                                     3
AQ$_SUBSCRIBERS                SYSTEM                                  1
BLOB                           SYS                                    25

...