select
column_name,
table_name,data_type ,data_length,data_precision,data_scale
from
user_tab_columns
where
column_name=
'字段名'
;
select
column_name,
table_name,data_type ,data_length,data_precision,data_scale
from
user_tab_columns
where
column_name=
'字段名'
;