oracle使用sql语句查询表结构

SELECT
–t1.Table_Name || chr(13) || t3.comments AS “表名称及说明”,
ROWNUM ,
t1.Column_Name AS “字段名称”,
t1.DATA_TYPE AS “数据类型”,
t1.DATA_LENGTH AS “长度”,
t1.NullAble AS “是否为空”,
t2.Comments AS “字段说明”,
t1.Data_Default “默认值”
–t4.created AS “建表时间”
–t3.comments AS “表说明”,
FROM cols t1
LEFT JOIN user_col_comments t2
ON t1.Table_name = t2.Table_name
AND t1.Column_Name = t2.Column_Name
LEFT JOIN user_tab_comments t3
ON t1.Table_name = t3.Table_name
LEFT JOIN user_objects t4
ON t1.table_name = t4.OBJECT_NAME
WHERE NOT EXISTS (SELECT t4.Object_Name
FROM User_objects t4
WHERE t4.Object_Type = ‘TABLE’
AND t4.Temporary = ‘Y’
AND t4.Object_Name = t1.Table_Name)
and t1.TABLE_NAME=‘要查询的表名称’
ORDER BY t1.Table_Name, t1.Column_ID;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值