ORACLE/DM 查询数据表结构

最新推荐文章于 2024-07-29 15:22:37 发布

初冬不见雪

最新推荐文章于 2024-07-29 15:22:37 发布

阅读量830

点赞数

分类专栏：学习笔记文章标签： sql 数据库 oracle

本文链接：https://blog.csdn.net/d178866718/article/details/126543698

版权

学习笔记专栏收录该内容

6 篇文章 0 订阅

订阅专栏

select t.COLUMN_NAME AS "列名", DATA_TYPE AS "数据类型",
CASE 
	WHEN DATA_TYPE='BLOB' OR DATA_TYPE='CLOB' OR DATA_TYPE='TEXT' THEN ''
	ELSE DATA_LENGTH
END AS "数据长度",
CASE NULLABLE 
	WHEN 'N' THEN '不能为空' 
	ELSE '' 
END AS "是否允许为空",COMMENTS AS "注释"
from user_tab_columns  AS t
INNER JOIN user_col_comments AS c
ON t.COLUMN_NAME=c.COLUMN_NAME AND t.table_name=c.table_name
where t.table_name = 'SOCIAL_INVESTMENT_PROJECT';