一、查询表字段:
1.Oracle数据库脚本:
-- 查询表字段 oracle
select UPPER(B.COLUMN_NAME) as FIELD_NAME,
UPPER(B.DATA_TYPE) as FIELD_DATA_TYPE,
case
when B.DATA_SCALE is null then
0
else
B.DATA_SCALE
end as FIELD_DECIMAL,
(case
when B.DATA_PRECISION is null then
B.CHAR_LENGTH
else
B.DATA_PRECISION
end) as FIELD_LENGTH,
case
when B.NULLABLE = 'N' then
'1'
else
'0'
end as IS_NULL,
C.COMMENTS as FIELD_COMMENT
from (select A.TABLE_NAME,
A.COLUMN_NAME,
A.DATA_TYPE,
A.DATA_SCALE,
A.DATA_PRECISION,
A.CHAR_LENGTH,
A.NULLABLE
from USER_TAB_COLUMNS A
where A.TABLE_NAME = UPPER('表名')) B
left join USER_COL_COMMENTS C
on B.TABLE_NAME = C.TABLE